Results 1 to 9 of 9
  1. #1
    drjabear
    Guest

    Counting Unduplicated Records

    I have a table that has many duplicate records. I would like to run one query (not two) that would give a count of the total number of unique records within the table. I am using Office 2000. Thanks for the help.

    Jason

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting Unduplicated Records

    Create a query based on the table and include all the fields you want to check for an upduplicated listing. Change the query property for unique values to yes.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  3. #3
    drjabear
    Guest

    Re: Counting Unduplicated Records

    Thanks for the help, but I was hoping to run a query that would give me an output that counted all of the unique records within a table. Any reccommendations?

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting Unduplicated Records

    If you create a query displaying the unique listing your status bar will display the total count of records displayed.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  5. #5
    drjabear
    Guest

    Re: Counting Unduplicated Records

    Right, but I was needing a query to return the count in its results whereby I could report on it.

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting Unduplicated Records

    You could create two queries: One with the Unique Values property set to Yes. Then create a second query with the first query as the record source. Turn on the Totals option (Summation symbol) and set the total to "Count"

    Enjoy!
    -MarkJ-

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting Unduplicated Records

    A report could be created that used the undup query as its data source and the a calculated field could return your count.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  8. #8
    drjabear
    Guest

    Re: Counting Unduplicated Records

    Mark,
    thanks, that is what I am going to have to do. I don't think there is any other way around this problem except creating two queries with one acting as the source table

  9. #9
    drjabear
    Guest

    Re: Counting Unduplicated Records

    Judy, Thanks, for my purposes I am looking to feed this info to another table. I don't think there is any other solution to my problem except creating two separate queries with one acting as the source table grouping all duplcate records and the other that actually counts the number of records in the first query. Thanks for your help.

Posting Permissions

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