Date query question.

[McArthurGDM]

Assume I have a Date field. The date values may either be filled in or they may be null.

So, you would do the Between Nz([begindate],#..#) And Nz([enddate],#..#) OR IS NULL. That’s simple enough.



However,

I only want the Nulls to not show up if the user inputs any criteria in the the [begindate] AND [enddate]. If the user inputs just a [begindate] or just an [enddate] or nothing at all – then displaying the Nulls is fine.

Does anyone know a way to do this?

[June7]

Not sure I understand "want the Null values shown if they choose not to enter any criteria and the Null values shown if they choose to enter some search criteria". Doesn't that say you ALWAYS want the records with null?

I don't use dynamic parameterized queries. I use VBA to construct filter criteria.

[McArthurGDM]

Basically, if they enter in search criteria for the [begindate] AND [enddate], I don't want any Nulls to show up. However, if they enter in criteria for the [begindate] OR [enddate], then I want the Nulls to be displayed. Also, in the case of not entering any criteria at all, displaying all information (including nulls) is fine.

[June7]

I would go with VBA and pass constructed filter criteria to form or report.

[McArthurGDM]

Would you know how to do that? Haha

Hit me with the barebones of the VBA code if you could.

[June7]

Review:

https://www.accessforums.net/queries...orm-45986.html