Return Multiple Records Query

D

David W

Hello All,
I have got a query that I am using to look through a table with thousands of
records and return multiple records based on multiple criterias like;
this is in the criteria field of the query
[forms]![filter1].[air1]
[forms]![filter1].[air2]
[forms]![filter1].[air3]
[forms]![filter1].[air4]
etc..
also I have got a second field that has the qty in it and it and it is set
to max to give me the largest number.
What I am wanting is to end up with something to show all of the criterias,
what I have got now is a query that only shows what is in the table. Can
this be done?
 
P

Pete

If youmean that you want to see the value of [forms]![filter1].[air1] ain the
query results then just add it as an extra column in the query grid.

Air1Param:[forms]![filter1].[air1]

and so on

Peter
 
Top