Input query options to receive 1, 2 or all records. 1

[everyda7]

I have a SUBCATEGORY Field. Within that field I would like to select, Images, Print Forms or both. These are the only options. Using the following I can receive either or:[Enter Images, Print Forms]. What can I do to receive the 3rd option which is all of them (everything).

 

[JerryKlmns]

If in a parameter query ...
The following example uses a table for branches, asking which branch name to show. If no name entered in the popup form, the query returns all!

PARAMETERS [WhichOne] Text ( 255 );
SELECT Branches.*
FROM Branches
WHERE (((Branches.Name)=[WhichOne])) OR ((([WhichOne]) Is Null));

Adjust this to your needs

 

[everyda7]

I received the following error message: "Invalid (dot) or ! or invalid parenthesis. I tried adjusting but no luck.

 

[PHV]

SELECT ...
FROM ...
WHERE SUBCATEGORY=[WhichOne] OR [WhichOne] Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[everyda7]

The code below worked:

Like "*" & [Please Enter Information] & "*"

Thanks for your help.