A simple date query

[Vav]

Hi Guys....

I got an easy one for you.....

I need to make a query that will find sales between two dates... Jan 1 and Mar 31...

The query is pulling information from a table, and the date is set to format "Date/Time".... so the record in my table looks like this 1/10/2004 ... i.e Jan 10 2004

What is the WHERE code..


I have done this many times before but i always go the users to enter int he parameters... i never hard coded it in before.

I tried putting " " around the date but it obviously produceses a syntax error or type mismatch error.

Thanks

 

[KenHigg]

Build it in the query builder using 'between 1/1/2004 and 1/31/2004'. Then examine the sql it generates if you need the sql statement.

???
kh