Query blank when no dates entered 1

[istone]

Hi,
I have a query with the following criteria:
Between form!Main!Begdate And form!Main!Enddate
Begdate and Enddate are 2 text boxes in the form Main.
This works perfectly.
I need help in making the query gives me all dates if I leave the 2 boxes blank. Right now if the 2 boxes are bank I get query with no data.
I hope my question is clear. Thanks in advance

 

[PHV]

You may try this:
Between form!Main!Begdate And form!Main!Enddate OR (form!Main!Begdate Is Null AND form!Main!Enddate Is Null)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[istone]

Great. thank you.