Create a report adding all the days of the week?

[afs24]

How do I create a report summing all the days of a week. I have a table with multiple Sundays with different numbers:
Example:
Day Total
Sunday 10
Monday 20
Sunday 30
Sunday 40
....the total is 100

I want my report to have Sunday one time, not 3x's with the total. The report should look like the following:
Sunday Monday
100 20

Lastly, how can I change a date in short format to a day. Example: 04/01/03 should change to Tuesday.

 

[afs24]

Just seeing if anyone had a chance to look at this yet???

 

[jobb]

First, add a number field to your table for the day of the week. Then do an update query, updating your new field to this :

Weekday([yourshortdatefield])

You will keep all the dates and have the number of the weekday (sunday=1, monday=2, etc.) .

If you want to have the weekday show, the easiest way to do this would be to include an additional table with 2 fields, the weekday #, and the weekday name. Join the weekday # with your other table to get the weekday names in there- You can do this in your original query, and group by the weekday name, so you can sum the weekdays.

HTH!