Sorting By Date

[sweetpea58]

Hey Guys,
I have a form with a list box containing departments. when i click on a department and then preview report i wanted to bring up a specific record entered on a specific date. therefore I havethe report based on a query. I needed to sort the information by date, so in the query i have the code:Between [Start Date] And [End Date] as a criteria under date added, and then based the report on the date added field, but when i enter the date the report gives me every date in that department and not the specified range. Can someone help.


Thanx

 

[statsman]

Try:
Between >=[Start Date] And <=[End Date]

 

[Pat Hartman]

Between [Start Date] And [End Date] is the correct syntax. Make sure that the date field you are comparing the arguments to is actually a date field and not already formatted.