| Nikolaos Sahtaridis 2005-12-31, 11:23 am |
| I am performing a set of very simple database queries in Microsoft Access,
that I want to automate instead of going through them all manually.
Namely, I possess a database of records as usual (the first field is a name,
the second date and the rest numerical, like height, weight, age etc...).
Lets say they represent persons.
I have another person (a 'newcomer' so to speak) and I try to find all the
records in my database whose height is, say, greater that this person's
height, the weight is 10% smaller than this person's weight etc etc. No
problem, so far. I just type a query and Access finds these records for me.
If I have two 'newcomers', I type the query twice etc.
But is there an automated way that Access can 'apply' this query to many
'newcomers', that I have stored in an Excel (or Access) file, so that I don'
t have to re-type it every time? This 'macro' will take this Excel (or
Access) file of 'newcomers' as input (say it contains 100 'newcomers'),
apply that same query for every newcomer in that file, and produce the
corresponding 100 Access files as output. For brevity, if, for some
newcomers, the outcome of the query is null, its table won't be produced.
Is there any straightforward way to accomplish that in Access or I have to
resort to high-level programming or something? Please respond directly to
nikos@winner.gr. Thank you in advance and Happy New Year to everyone!
Nick Sahtaridis
nikos@winner.gr
|