Query

[sam]

Can i somehow set a query to choose ALL items if no
specific item is chosen when prompted?
EG
In the division field there are divisions A B C D and E.
I would like to run the report for maybe divison A and
would put A in the pop up prompt - but if no division is
chosen then it's because I would like to run the query for
ALL divisions?

 

[John Spencer (MVP)]

Your criteria should read something like:

Field: Division
Criteria: [Which Division?] or [Which Division?] Is Null

This will return all records if [Which Division?] is left blank or
just matching records if something is entered. The criteria is entered in ONE
criteria cell.

Also, if Division is ALWAYS filled (never blank) you could use criteria of

Field: Division
Criteria: LIKE Nz([Which Division?],"*")

The first method will return all records, including those where division has not
been filled in.