Between 2 Dates Query

[stuartandwil]

I want to chart my records by date, I have a query that selects the relevant records and have >=[Enter Date] in the criteria field. This gives me all records after or including date. I want it to prompt for an end date so I can chart for a given period or week. I assumed i would be able to write

>=[Enter Start Date] and <=[Enter End Date] in the criteria but alas this does not work. What am I doing wrong ?

Many thanks

Stuart

 

[bat17]

It works fine for me in what way is it not working for you? not returning any records or not the ones that youe expected or what?

Peter

 

[stuartandwil]

It provides records between 2 dates, however if I decide that I want just 1 days records entering for example Start 9/9/03 End 9/9/03 I get nothing.