Group and calculate by day of week

[Kath]

Hi, I'm hoping someone can help me; not very good with MS Access yet and definitely not versed in VB. Using Access 2002-2003. What I'm trying to do is Group / calculate on 2 types of incidents Sorted (and 'summed up' by Day of the week. So if we had Incident1 3 times Sunday this week, 4 times on Sun last week, we'd see 7 Incident1's on Sunday. Add to that, ie: 4 Incident 2's on Sunday this week and 1 Incident2 last week, we'd see 5 Incident2's also under Sunday. With those added together for Sunday - seeing 12 total incidents for Sundays. Does that make sense? I've searched and I'm able to get the query to use 1-7 as days of the week, but don't know how I can transfer that to the report (I already have the query as the source for the report, but only see the table's fields as options for the report).