Multiple Data

[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

 

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

 

[Guest]

Even without grouping you can set property to Hide Duplicates.

 

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