Between 2 Dates or Enter for All

[fenhow]

Hi,

I am using this in a query and it works great, however if I wanted to just run all records regardless of date is there anything I can add to this to give the option of "Hit Enter For All"?

Thanks.

Fen How

Between [Enter Start Date] And [Enter End Date]

 

[vbaInet]

Two ways (in order of difficulty) :

1. You create 2 seperate queries and handle the IF statement on your form from which you decide which query to run.

2. You construct the SQL string using vba and still handle the IF statement on your form.

 

[DCrake]

Take the parameters out of the query and get them from a form. Only pass the range if the user has entered one.