Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Exclamation Unanswered: DCount, Select Query, Report

    Please bear with my elementary understanding of databasing. Here is what I have:

    I have a table called CHILDINFO, and I am running a select query called NCA to extract information between certain dates. That query works just fine. I am building a report based on this select query. Here are some fields and sample date of the NCA query on which my report is based:

    DATE------GENDER------AGE------RACE
    1/2/01-------M-----------6-------caucasian
    2/3/02-------F-----------8--------African American
    3/2/03-------M----------7---------caucasian

    In the report, I want to count the number of males based on the select query. I understand that I need to use a DCount, but I get the #Error when I use the following statement. I think it has something to do with NCA because I can use this DCount statement on my CHILDINFO table without any problems.

    =DCount("[GENDER]", "NCA", "[GENDER] = 'M'")

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    I have a table called CHILDINFO
    =DCount("[GENDER]", "NCA", "[GENDER] = 'M'")
    Your DCount statement is looking for a table called NCA. Is this the name of your query????

    Why use Dcount when you could use a query to return this information?

    You could assign a if statement to your original query. In a field type if ([Gender]="M",1.0) and then run another query to return the sum of the 1.

Posting Permissions

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