Duplicate Inquiries

  • Thread starter How to capture duplicate data w/ a query
  • Start date
H

How to capture duplicate data w/ a query

When running an Access report, I'm trying to capture duplicate inquiries
only. We have the field set up to show all ID numbers. I want to be able to
put data in the design field that will only show me ID#'s that are
duplicates. Any suggestions?
 
J

Joan Wild

"How to capture duplicate data w/ a query" <How to capture duplicate data w/
a [email protected]> wrote in message
When running an Access report, I'm trying to capture duplicate inquiries
only. We have the field set up to show all ID numbers. I want to be able
to
put data in the design field that will only show me ID#'s that are
duplicates. Any suggestions?
Click to expand...


Base your report on a query rather than your table.

I the queries tab, click on New and in the dialog choose 'Find duplicates
query'. It will quide you through the creation of the query. Then base
your report on this query.
 
H

How to capture duplicate data w/ a query

Thanks for the help, but I think I phrased my question incorrectly. I have a
query which gives me data displaying Customer ID number, the sequence, date
opened, etc... I want to be able to run the query so that it only shows me
duplicate ID#'s under the same sequence. Is this possible?
Again, thanks for the help!
 
J

Joan Wild

"How to capture duplicate data w/ a query"
Thanks for the help, but I think I phrased my question incorrectly. I
have a
query which gives me data displaying Customer ID number, the sequence,
date
opened, etc... I want to be able to run the query so that it only shows me
duplicate ID#'s under the same sequence. Is this possible?
Again, thanks for the help!
Click to expand...


SELECT YourTable.Sequence, YourTable.CustomerID
FROM YourTable
WHERE (((YourTable.Sequence) In (SELECT [Sequence] FROM [YourTable] As Tmp
GROUP BY [Sequence],[CustomerID] HAVING Count(*)>1 And [CustomerID] =
[YourTable].[CustomerID])))
ORDER BY YourTable.Sequence, YourTable.CustomerID;

Put that in the SQL view of a new query.

If I've still misunderstood, perhaps you could post sample data, and sample
output.
 
Top