Query parameter is null (XP)

Topic

New Reply

I usually use Like [cboValue] and a union query with * to return all records but now I have a date field and this approach does not work. I remember that I used another method to do a similar thing years ago using an ‘or is null’ or something similar to get all the records if a parameter was left as null but I can’t make it work – can you steer me in the right direction.

Reply | Quote

Replies

Try the thread starting with post 336,509 . Everything you want to know about Union queries and using null values (not to mention empty strings).

Reply | Quote

Sorry that’s not what I’m after. In the solution I used a few years ago did not use a union query.

The unbound form supplying the criteria was allowed to provide a null value and the query returned all records when supplied with a null.
after much fluffing around I got it –
WHERE (((tblRunner.Runner_Name)=[Forms]![frmCriteria]![cboRunner])) OR ((([Forms]![frmCriteria]![cboRunner]) Is Null))

Reply | Quote