Problem with date sorting

[danikuper]

I have a report running based on a query. In this query one of the fields is DATE. When running the query, I have no problems in getting the results I want and in sorting by date.

However, when running the report grouped by month my dates are completely messed up without any proper sort order. In my report I also have the Date field being sorted in ascending but it doesn't seem to matter.

My tables are storing dates in mm/dd/yyyy format and my report is also using this format.

Any ideas of why this is happening and how to fix it?

Thanks in advance!

 

[cpod]

You need to list your date field twice in the Grouping and Sorting dialog box. Once to establish your group header/footer and once to set the sort order.

 

[danikuper]

I tried that but it's still not working.

Any other ideas?

thanks for the try

 

[danikuper]

I'm attaching a screenshot of the report I'm talking about. I tried adding the Date field twice in the Sorting and Grouping box and also tried to add it to the Order By property of the report (as shown in my screenshot).

Hope this clarifies things.

thanks again!

 

[danikuper]

Ops! forgot the attachment... sorry! here it goes.

 

[Rich]

Remove the Order By from the property sheet

 

[danikuper]

Did that. Still not working... what could this possibly be?!

I'm almost at the point of deleting and creating the report from scratch.

 

[cpod]

It looks like it should work.

If you want to send me the database - table/s (structure only), query and report I will take a look at it: c_pod@hotmail.com

 

[cpod]

Just occured to me. In your screen shot you have two other entries in the grouping and sorting dialog box between the two entries for your date. It's sorting the header/footer by the month, then the detail section by the other two fields first then, lastly, by the date.

Move the second date entry to the second position.

 

[danikuper]

cpod, you're a genius!!!!

Moving the second date entry just below the first one solved the problem. Hurrayy!!!!

Thank you so much!

 

[cpod]

Just occured to me. In your screen shot you have two other entries in the grouping and sorting dialog box between the two entries for your date. It's sorting the header/footer by the month, then the detail section by the other two fields first then, lastly, by the date.

Move the second date entry to the second position.