Make Criteria non-mandatory

[hopkins]

I have a set of criteria that require user input when generating the query-based report.

3 for entering the project number a user would like to search [Enter first collator] Or [Enter second collator] Or [Enter third collator]

Only the first collator needs to be entered to have a successful report generated.

Then I added a BETWEEN criteria for dates Between [Type the beginning date (mm/dd/yyyy):] And [Type the ending date (mm/dd/yyyy):]

This seems to be mandatory (runs fine if the user specifies dates)and I would rather it not be.

I then tried to add another criteria [Enter line Object] and this also seems to be mandatory and I would rather it not be.


How do I make a crietia non-mandatory to run a successful query?

Any hints / ideas would be most welcome!

Trish
Trish

 

[FoFa]

In a case such as this, you maybe better served using a Form to ask for the criteria, and supply the parameters to the query via VBA, or (my preference) create the SQL on the fly, but it depends how you are using it.