I have a database I made. I'd like to add another button. When the user clicks the button a parameter window comes up.
I want the user to enter two dates
an example would be 1/1/08 and 12/31/08
The query results should then show all the invoices within the above range.

What is the expression code I would enter to make this work?
If it helps the field name is DateEntered

Thanks

 

I found my answer...
Between [Beginning Date] And [Ending Date]
If anyone knows a better way please let me know

 

if you have a lot of rows, i'd index on on the dates...

 

Thanks idivinag I might try that. I only have 290 rows

 

lol...

ok... that's too small. but what the heck. it's good practice.

besides, you'll learn about indices and crap.