displaying all the duplicate records in a duplicate query

  • Thread starter Thread starter Paul James
  • Start date Start date
P

Paul James

I've been using Total queries to count the numbers of duplicate records in a table, where one query field is a Group By and the other is a Count of the same underlying field. This results in a query that displays the duplicate record values in one field, and the number of records in each of those groups in another query field.

The specific query parameters I'm using are:

Field Left(Name,6) Name
Total Group By Count
Criteria >1


I'm trying to figure out a way to create a query that would display each of the individual (duplicate) records in each group, instead of just showing the count of the records within each group. Can anyone tell me how to do this?

Thanks in advance,

Paul
 
Using the Find Duplicates Query Wizard should be able to do this for you.

Select queries in you database window. Then click the new button, select
Find Duplicates Query Wizard, and follow the directions.

Also, please use text format when posting to the newsgroups. RTF/HTML wastes
bandwidth and increases download times.

Good luck.

Sco

I've been using Total queries to count the numbers of duplicate records in a
table, where one query field is a Group By and the other is a Count of the
same underlying field. This results in a query that displays the duplicate
record values in one field, and the number of records in each of those
groups in another query field.

The specific query parameters I'm using are:

Field Left(Name,6) Name
Total Group By Count
Criteria >1


I'm trying to figure out a way to create a query that would display each of
the individual (duplicate) records in each group, instead of just showing
the count of the records within each group. Can anyone tell me how to do
this?

Thanks in advance,

Paul
 
I would save this query, and use it as a recordset for a
second query, and link [Name] in your
first query, with the Name field, in your underlying table,
and display all the fields from the
underlying table you want to see.



in message I've been using Total queries to count the numbers of
duplicate records in a table, where one query field is a
Group By and the other is a Count of the same underlying
field. This results in a query that displays the duplicate
record values in one field, and the number of records in
each of those groups in another query field.

The specific query parameters I'm using are:

Field Left(Name,6) Name
Total Group By Count
Criteria >1


I'm trying to figure out a way to create a query that would
display each of the individual (duplicate) records in each
group, instead of just showing the count of the records
within each group. Can anyone tell me how to do this?

Thanks in advance,

Paul
 
Thanks for the reply and the info.

You're right - the query wizard gave me exactly what I wanted.

Regarding the RTF, I don't usually use it in my messages to newsgroups, but
I wanted to use courier font so the columns in my example would line up
properly. I didn't know any other way to get the courier in there.

I always want to follow proper newsgroup etiquette, so if using RTF causes
any problems, I don't want to do it. But since this is an Access newsgroup,
how do contributors get their columns to line up so they're readable without
using RTF?

Paul
 
Thanks for your reply, Margaret.

I tried following your suggestion in detail by building a second query using
the first query, adding the underlying table and linking them on the [Name]
fields in both tables. However, it didn't cause the query to display all of
the duplicate records.

Also, I'm able to display any additiona fields by just adding them to the
first query and setting their "Total" row to "First."

Paul
 
Inline...

Sco

Paul James said:
Thanks for the reply and the info.
Click to expand...

You're most welcome.
You're right - the query wizard gave me exactly what I wanted.
Click to expand...

Excellent! I just love a happy ending. :-)
Regarding the RTF, I don't usually use it in my messages to newsgroups, but
I wanted to use courier font so the columns in my example would line up
properly. I didn't know any other way to get the courier in there.
Click to expand...

Just throw in a few extra spaces if the alignment is that important.
I always want to follow proper newsgroup etiquette, so if using RTF causes
any problems, I don't want to do it. But since this is an Access newsgroup,
how do contributors get their columns to line up so they're readable without
using RTF?
Click to expand...

The problem is the message size. A lot of people set download limits.
Because RTF grows 2 to 4 times faster than plain text, your message might
not get download by someone that can help.

Also, because of the idiots that have found ways to insert malicious script
into HTML, there are some people that won't even download a message that is
not plain text. Again, your message might get missed by someone that could
help.
Paul
Click to expand...
<snip>
 
Back
Top