Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    1

    Unanswered: Count and Sum in Access

    Hi. I am new to the forum and new to access...
    I have created a table to record the number of calls we receive on a toll free line. I need to record DateCalled, Gender, Language, County, ReasonforCalling.
    I then created a query to pull the information for each month(Used a parameter to select the dates needed). For each month i need to see "Total Calls", and i need the gender, language and county to be counted. I was able to get the numbers, however if someone calls on August 2 from Westmorland who is english and female and they call about Custody/Access, the count function isnt giving me the proper number for my report.

    Not sure if this makes sense...

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    What's the SQL of the query you use?
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •