weekdays on reports....

[Guest]

i really need some help.... its porbably dead simple and obvious but cant for
tyhe life of me fiqure it out....

ive created a database to organise where the kids areon certain days over
the holidays.... this then produces a report.... i want to have it sorted by
week day mon, tues, wed, thurs etc..... how ever it sorts them
alphabetically.... fri, mon tues thurs......

anyone have any idea to help i would be very greatful

bigdog85

 

[SA]

bigdog

Use the DatePart function in new field on your Date field, to pull the day
of the week (i.e. 1, 2, 3) and sort ascending on that field. You don't have
to display the field in your report