Grouping on Day of the week in an Access Report 1

[TrishMcK]

Hi,
I am using Access 2000 to design a database for classroom bookings for a school. The report at the end has to be grouped by day ie all the bookings for a Monday (for a the whole month) in one group. I have a date field and a field call Bookday which is generated from the date using BookDay: Format([Date],"dddd" in the query which provides the data for the report. The query prompts for the date to run from.

I have grouped on bookday which does exactly as I want the only problem is it sorts alphabetically on bookday too which means Friday is the first day in the report and I would like it to be a Monday.

Is there maybe a day code or something that I could sort so that my report would start on a Monday thru Friday? I would apprceiate any help with this.


Regards

Trish McK

 

[CautionMP]

Try the Weekday() function. It will return an integer 1-7 based on the date and the FirstDayOfWeek argument.

 

[TrishMcK]

Fantastic ...works a treat!

This struggling little database designer from Scotland thanks you for saving her a load of time.

Cheers

TrshMcK