Report Won't Sort By MaxOfDate Field (1 Viewer)

sherlocked

Registered User.
Local time
Yesterday, 22:06
Joined
Sep 22, 2014
Messages
125
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

Well-known member
Local time
Today, 01:06
Joined
Apr 9, 2015
Messages
4,339
MaxOfClassDate should be in the query.
Is it in the query?
yet wont show in report grouping?
 

sherlocked

Registered User.
Local time
Yesterday, 22:06
Joined
Sep 22, 2014
Messages
125
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

Wino Moderator
Staff member
Local time
Yesterday, 22:06
Joined
Aug 30, 2003
Messages
36,118
Is it a date/time field or text? A text field will sort alphabetically.
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 22:06
Joined
Aug 30, 2003
Messages
36,118
What exactly do you mean by "does not sort successfully"? Are there any other sorts applied? Can you attach the db here?
 

sherlocked

Registered User.
Local time
Yesterday, 22:06
Joined
Sep 22, 2014
Messages
125
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

Wino Moderator
Staff member
Local time
Yesterday, 22:06
Joined
Aug 30, 2003
Messages
36,118
It's not sorted in alpha order? Can you post a pic of the report in design view and preview?
 

sherlocked

Registered User.
Local time
Yesterday, 22:06
Joined
Sep 22, 2014
Messages
125
Sure, here you go :)
 

Attachments

  • DesignView.PNG
    DesignView.PNG
    20.2 KB · Views: 54
  • Preview.PNG
    Preview.PNG
    15.7 KB · Views: 51

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 22:06
Joined
Aug 30, 2003
Messages
36,118
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

Registered User.
Local time
Yesterday, 22:06
Joined
Sep 22, 2014
Messages
125
how foolish of me! it's always something simple and silly.

Thanks, I'm in business now :)
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 22:06
Joined
Aug 30, 2003
Messages
36,118
Happy to help! It's often the little things that trip us up.
 

Users who are viewing this thread

Top Bottom