Custom sort order for a group in a report

G

Guest

I have a report that is grouped on a field that contains the days of the week
("Monday", "Tuesday", ... ). I also have it set to display each on a
separate page ( so, all Monday's are on one page, all Tuesday's on another,
etc.) but I can only sort the group ascending or descending so the pages are
ordered Friday, Monday, Thursday, Tuesday, Wednesday or vise versa if I
choose descending. What I would like is to have the pages ordered Monday,
Tuesday, Wednesday, etc. I am using Access 2002. Thank you for your help.
 
D

Douglas J. Steele

Add a field to the underlying query that returns Day([MyDate]), and group on
that field (while displaying the other one)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



stmguy said:
I have a report that is grouped on a field that contains the days of the week
("Monday", "Tuesday", ... ). I also have it set to display each on a
separate page ( so, all Monday's are on one page, all Tuesday's on another,
etc.) but I can only sort the group ascending or descending so the pages are
ordered Friday, Monday, Thursday, Tuesday, Wednesday or vise versa if I
choose descending. What I would like is to have the pages ordered Monday,
Tuesday, Wednesday, etc. I am using Access 2002. Thank you for your
Click to expand...
help.
 
G

Guest

How would you enter this into the query?

Douglas J. Steele said:
Add a field to the underlying query that returns Day([MyDate]), and group on
that field (while displaying the other one)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



stmguy said:
I have a report that is grouped on a field that contains the days of the week
("Monday", "Tuesday", ... ). I also have it set to display each on a
separate page ( so, all Monday's are on one page, all Tuesday's on another,
etc.) but I can only sort the group ascending or descending so the pages are
ordered Friday, Monday, Thursday, Tuesday, Wednesday or vise versa if I
choose descending. What I would like is to have the pages ordered Monday,
Tuesday, Wednesday, etc. I am using Access 2002. Thank you for your
Click to expand...
help.
Click to expand...
 

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

Show Data In Report On One Row Instead Of In A Column 2
How do I change the sort order of days of the week? 2
Countif w/semicolon separated values 4
group by week 1
Sort days by current day 1
report in access (Count) 1
grouping with a total 1
How to check for missing required daily entries (records) 10

Top