Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Report Counting and Grouping, rusty brain can't remember

Report Counting and Grouping, rusty brain can't remember

Report Counting and Grouping, rusty brain can't remember

I have a problem that I think should be simple but it's been a few years since I last worked with Access and I'm rusty and for some reason can't figure this out. I have a very simple table layout basically we get a Request and a Request can have many Services. In the end I want to total the service times (RequestServices table) and count the origins types for each request (Request table) basically I want to know how many walk ins, how many calls etc. The problem I'm having is I am counting at the detail (ServiceRequest) level instead of the higher (Request) level I want. I've attached some pics below to help explain.

Here is my table layout...

Here's my report so far...

The Region Group is where I want to add the count. I want to know the number of walk ins for the given region. So basically this report is showing 2 Requests (id's 37 & 39), #37 has 8 services, #39 has 2 services. At the top next to Region I've added a count for Walk-In's but it's counting all the detail records. I want that counter to read 2, there are only 2 REQUESTS (37 & 39)

I'm guessing there's a simple solution I just can't make my brain find it. Currently the Walk In total's control source is =Sum(IIf([Origin]="Walk-In",1,0)). How do I get it to count only the 2 REQUESTS instead of each SERVICE?

Thanks in advance for your help, please let me know if anything isn't clear or my images aren't showing up.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close