displaying all the duplicate records in a duplicate query

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 a

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

"Paul James" wrote 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 a

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.



"Paul James" wrote
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 a

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


"M.L. Sco Scofield" wrote in message
...
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

"Paul James" wrote 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 a

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 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



"Margaret Bartley" wrote in message
...
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.



"Paul James" wrote
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 a

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

Inline...

Sco

"Paul James" wrote in message
...
Thanks for the reply and the info.


You're most welcome.


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


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.


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?


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

snip

Ok. Thanks for the info.