Report Won't Sort By MaxOfDate Field

[sherlocked]

Hi experts,

I have a report that is based on a query which determines the most recent time a student attended class. It has a "MaxOfClassDate" field which I would like to use to sort my report.

I have indicated in the Sorting & Grouping window that I would like to sort my report by this field but it is not working.

Is there a reason for this, and can it be corrected?

Thank you in advance for your assistance!

 

[Ranman256]

MaxOfClassDate should be in the query.
Is it in the query?
yet wont show in report grouping?

 

[sherlocked]

It's in the query, and does show as an option to sort. However, the report does not sort successfully after making this selection

 

[pbaldy]

Is it a date/time field or text? A text field will sort alphabetically.

 

[sherlocked]

it's a date field

 

[pbaldy]

What exactly do you mean by "does not sort successfully"? Are there any other sorts applied? Can you attach the db here?

 

[sherlocked]

Hi,

I mean that although I have the sorting/grouping set to sort by this field in ascending order, when I view the report, it is not sorted. I cannot attach the DB as it is proprietary, sorry

 

[pbaldy]

It's not sorted in alpha order? Can you post a pic of the report in design view and preview?

 

[sherlocked]

Sure, here you go

 

[pbaldy]

The primary sort is on FullName (because you're grouping on it), so the date sort would only apply to records for the same full name.

 

[sherlocked]

how foolish of me! it's always something simple and silly.

Thanks, I'm in business now

 

[pbaldy]

Happy to help! It's often the little things that trip us up.