1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Group/Sum by days of the week

Discussion in 'Business Applications' started by KSanz, Jan 28, 2013.

Thread Status:
Not open for further replies.
  1. KSanz

    KSanz Thread Starter

    Dec 1, 2011
    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).
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 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1087261

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice