Ascending Order

[skydiver]

Access 2003. Why isn't the "Time" field sorting in ascending order just like the date. It sorts ascending in query, but not in report?

 

[DCrake]

Have you set the sort order in the report?

 

[skydiver]

I don't see a sort order in the field's property.

 

[skydiver]

My report is based on the query I have set for ascending order.

 

[skydiver]

Alright, let me back up a bit here. I have a "Date" and "Time" field (separate fields). Some data is entered more than once on the same day. I want to sort both the date and time in my report based on my query.

 

[boblarson]

Reports need you to set the sort order in the SORTING AND GROUPING of the report. The sorting on queries very rarely comes over to reports.

 

[skydiver]

Got it! It worked! Thanks Bob!!!

 

[boblarson]

Got it! It worked! Thanks Bob!!!

Thank David too - he was trying to steer you that direction but I just picked you up and plopped you down in front of it.

 

[skydiver]

You're right! Sorry Dave. You did put me on the right track. You guys are great!!!