Results 1 to 3 of 3
  1. 09-10-2014, 03:22 AM #1
    Mohmand
    Mohmand is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2014
    Posts
    2

    Post Count Unique Records in a Report


    I Have a Problem With Count Unique Value in a Report Footer ...
    This is a pic of my report ...
    Click image for larger version.  Name: pic.jpg  Views: 13  Size: 89.6 KB  ID: 18077

    I Need to Know Quantity of Group Numbers per Province But not Duplicate.
    Reply With Quote Reply With Quote
  2. 09-10-2014, 06:08 AM #2
    ranman256's Avatar
    ranman256
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    You can assign to the text box a DLOOKUP("[COUNT]","qsCountMyUniqRecs")
    where qsCountMyUniqRecs is a query that does a uniq count of the query used in the report.

    You just cant do it in this report using what you have.
    Reply With Quote Reply With Quote
  3. 09-10-2014, 10:44 PM #3
    Mohmand
    Mohmand is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2014
    Posts
    2
    Tnx Dear ranman256 to reply ...
    Can You Explain More and step by step, bcs i am new in Access ...
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Count unique customers in report header
    By hithere in forum Reports
    Replies: 7
    Last Post: 02-08-2013, 12:47 AM
  2. Unique queries - Unique Count
    By bigfish in forum Queries
    Replies: 7
    Last Post: 03-14-2012, 01:28 PM
  3. Count unique records - no duplicates
    By Kevo in forum Queries
    Replies: 4
    Last Post: 08-15-2011, 01:19 AM
  4. Populate report with unique records chosen from a form
    By m1nd64m3 in forum Reports
    Replies: 7
    Last Post: 07-26-2011, 02:15 PM
  5. Count Unique Records
    By PonderingAccess in forum Queries
    Replies: 2
    Last Post: 08-19-2010, 06:54 AM

Tags for this Thread

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums