Group/Sum by days of the week

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

KSanz

Thread Starter
Joined
Dec 1, 2011
Messages
1
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).
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top