Adding ALL to the query criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

I have a report based on a query that has a [Enter type] criteria; there are
many types that should be selected; how do I add ALL to get all the types in
the report?


Thank for the help,

Dan
 
I much prefer to use controls on forms to set my criteria, however, if your
field name is [Type] then you can change your parameter to:
Nz([Enter Type or press enter for All Types], [Type])
This assumes all records will have a value in the Type field.
 
Perfect! Thanks, Duane!

Dan

Duane Hookom said:
I much prefer to use controls on forms to set my criteria, however, if your
field name is [Type] then you can change your parameter to:
Nz([Enter Type or press enter for All Types], [Type])
This assumes all records will have a value in the Type field.

--
Duane Hookom
MS Access MVP
--

D said:
Hi:

I have a report based on a query that has a [Enter type] criteria; there
are
many types that should be selected; how do I add ALL to get all the types
in
the report?


Thank for the help,

Dan
Click to expand...
Click to expand...
 
Back
Top