Pulling Back Duplicate Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I want to design a report to pull back data where there may be more than one
record for a client like so:

Client# Product#
123456 8888
123456 1199
111111 9988
111111 1199

How can I use the Client # to pull back all instances of product #s??

Thanks
 
Use a Find duplicates query for your report:
SELECT yourtable.[client#], yourtable.[product#]
FROM yourtable
WHERE (((yourtable.[client#]) In (SELECT [client#] FROM [yourtable] As Tmp
GROUP BY [client#] HAVING Count(*)>1 )))
ORDER BY yourtable.[client#];
 
Thank you. I can't wait to try it.

jahoobob via AccessMonster.com said:
Use a Find duplicates query for your report:
SELECT yourtable.[client#], yourtable.[product#]
FROM yourtable
WHERE (((yourtable.[client#]) In (SELECT [client#] FROM [yourtable] As Tmp
GROUP BY [client#] HAVING Count(*)>1 )))
ORDER BY yourtable.[client#];
Hi,

I want to design a report to pull back data where there may be more than one
record for a client like so:

Client# Product#
123456 8888
123456 1199
111111 9988
111111 1199

How can I use the Client # to pull back all instances of product #s??

Thanks
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging two rows into one 5
Multiple query criteria, results to new table 1
Form Question (I think): Need to create columns of data as well as 1
Excel To Access: Transfer multiple rows from excel at the same tim 2
Concatenate multiple records in query 2
Pulling a report with multiple last names 2
Combine Duplicates in Query 0
Sorting Records 2

Back
Top