weekdays on reports....

B

bigdog85

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
 
S

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
 

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

conditional running sum 7
CrossTab report "super" columns 5
Line charting the same series using data from multiple sheets? 1
Access 2007 sort by day of week 3
Condensing data from one field for one record 2
Next weekday ... 3
Create a calendar report in access 3
Set a recurrance every other weekday. 1

Top