Date sort not working?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I built a monthly report, based on a query, that returns records if the date (short format) falls within a specified month. On the query, I have the dates sorted in ascending order and on the report's sorting and grouping, I have the dates set to sort in ascending order. However, when I view the report, the dates are all out of order.

Does anyone have any suggestions as to what I am doing wrong?

Thanks,
Carrie
 
Are you formatting the date field in the query? You comment regarding (short
format) suggests this. I recommend to never format any fields within a
query.

--
Duane Hookom
MS Access MVP


Carrie said:
Hello,

I built a monthly report, based on a query, that returns records if the
Click to expand...
date (short format) falls within a specified month. On the query, I have
the dates sorted in ascending order and on the report's sorting and
grouping, I have the dates set to sort in ascending order. However, when I
view the report, the dates are all out of order.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping/Sorting by Date 4
ordering by date in a subreport 1
Sort not working correctly 6
Sorting & Grouping Problem 4
Earliest Date 5
Question cc Sorting reports into a specific order 1
Sorting dates within groups. 2
Report Sorting Problem 2

Back
Top