Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counting records (2003)

    O have a database that summaries a lot data. It is grouped by Company code (we have 12), type of review (2) and then it adds the reimbursements amounts. Within the report it sorts by audit number. I have 805 records. There are only 32 audits. I need to have a count of unique audit numbers at the bottom where I display all my grand total information. Everything I try (which is limited) gives me 805 audits. How can I +1 when there is a change in audit #??? Or is there another way?

    Thanks,
    Deborah

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Counting records (2003)

    I'd create a query qryAuditNumbers that returns the unique audit numbers, e.g.

    SELECT DISTINCT [audit_number]
    FROM [some_table]

    Place a text box on your report with control source

    =DCount("*", "qryAuditNumbers")

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    South Carolina, USA
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting records (2003)

    Hans,

    I was on the right page but I could not get it to work. I have the field name in the Dcount instead of the query. Thanks for your help. It worked and I feel good that I at least was on the righ path!

Posting Permissions

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