Multiple Data

D

David

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
 
J

James

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

Jeff Boyce

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