Suppress duplicate CompanyName

G

Guest

Hi,

I have following query results sorted on Customer Name.
CustomerName OrderNumber

ABC 1245
ABC 4878
XYZ 1000
XYZ 1200
OPQ 1300

I want the query not to repeat duplicate CustomerName and give result like
CustomerName OrderNumber

ABC 1245
4878
XYZ 1000
1200
OPQ 1300

Please advise how to stop duplicate CustomerName.

Thanks,
Rakesh
 
D

Duane Hookom

Try set the Hide Duplicates property to yes in your report. If this has to
be in a query, there is no easy method.
 
J

Jeff Boyce

As Duane points out, queries return ALL the data you specify. If you wish
to only SEE the CustomerName for the first "row", use a report to display
what the query returns, and use the Hide Duplicates property.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 

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

Rank Students as per Total Marks 8
Identify Duplicates (Group Records First) 6
Find Duplicate records 3
Duplicates by Partial Matching (MS ACCESS) 5
Finding the Nth instance in a query 1
How to build query 8
How to Sort by Count the Max nos of Unique text values in Pivot Ta 1
Exporting query with duplicates 4

Top