Multiple Data

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

Guest

I have 4 colums I need to display all data it looks like this
itemcode description ordernumber cost

however I may have the same item code over and over but I only want to show
it once what do I need to do.. Thanks for help
 
if the whole row is distinct you can add DISTINCTROW to your select statment
like this:
select distinctrow * from table

or you can build a report and grouping (use the wizard to learn)
 
David

That depends. Where are you trying to do this?

In a query? Then use James' approach, either in SQL or by setting the
Unique Values property to Yes.

In a report? Then use Karl Dewey's approach and set the Hide Duplicates
property to Yes.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top