Multiple queries in Access

[Niko Sahtaridis]

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? You may also respond
directly to
(e-mail address removed). Thank you in advance and Happy New Year to everyone!

Nick Sahtaridis
(e-mail address removed)

 

[Rob Oldfield]

Your description of what you want is, as far as I can tell, exactly how
Access queries work by default. That makes me think that when you are
"typing the query twice" you're doing something that isn't quite right.

Could you describe exactly what you're doing?