Return Multiple Records Query

  • Thread starter Thread starter David W
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
ADO.NET RPC Slower than Management Studio 2
creating multiple instances of an enumerator 5
Requery control not working correctly 1
VBA to address first visible cell in Column "D" after filtering 2
DISTINCTROW doesn't yield off unique rows in one of my columns 1
Like is Null Query from Form 3
Criteria to return all records if selection from form is null 3

Back
Top