Help With Userform Query

[mMike01]

Hello, I've made a database for my wife to store audit information, and for her to retrieve data in nice reports I'm making userforms.



I've made a userform that has multiple query criteria, such as "Employee ID", "Audit Form ID", and "Patient Number". My first problem was running this userform when one of these fields was null the queries would retrieve no data, but I got around this by using an IIF statement in the query. for a generic example I did iif(userform field Is Null,[Employee_ID],userform field). This worked great, but I want to add another set of filtering criteria for date range set on a field I call "Audit_Date".

Ive set the userform up with a Begin Audit Date and End Audit Date fields and used the between expression in the query to retrieve a date range. It worked fine, however if I leave any of the dates null, I retrieve no data. Adding an IIF statement to try and get around this isn't working for me with the dates.

Any suggestions how to have the userform query run if dates are not entered?

Thanks in advance.

[pbaldy]

Use the Nz() function and dates outside the possible range:

Between Nz(Forms!FormName.StartDate, #1/1/1990#) And Nz(Forms!FormName.EndDate, #12/31/2029#)

[mMike01]

Thanks Pbaldy,worked perfectly.

Thanks again.

[pbaldy]

Happy to help!