WHERE statement (between) in a query

[bignate]

I use this


'WHERE ((OperationalRiskEventTable.DateReported)>=Forms!U pdateForm!UDateBegin And (OperationalRiskEventTable.DateReported)<=Forms!Up dateForm!UDateEnd)'
in a query by form.
The problem is that you have to enter a date in the between values for results to show. If I don't enter information into a different field such as Full Name but I enter in 40 into Age then everyone that is 40 years old will show. On the other hand if I enter 40 into the Age field but I leave the Date Reported fields empty then no results will show.

How can I change it so that I don't have to enter dates into the date reported fields for results to show?

Thanks

[June7]

Try Nz:

WHERE OperationalRiskEventTable.DateReported BETWEEN Nz(Forms!UpdateForm!UDateBegin,#1/1/1900#) And Nz(Forms!UpdateForm!UDateEnd,#12/31/2900#)

BETWEEN AND operator is inclusive for the range ends.

[bignate]

Thanks June7 that was what I needed