Criteria For Parameter

[dbernier22]

I need criteria for a query date parameter: if I press enter in the empty box I get all dates. Please help

 

[EMP]

Put the criteria in a new column in the query grid like this (using the correct date field name):-
----------------------------------------
Field: [DateFieldName]=[Enter a date] Or [Enter a date] Is Null

Show: uncheck

Criteria: True
----------------------------------------

See Jon K's Basic Criteria Format in the Sample Databases forum:-
http://www.access-programmers.co.uk/forums/showthread.php?t=103312

^