Reduce Many Instances of the Same Number to One

[JohnM]

I have a data base that records, amongst other things, Purchase order
numbers along with the items ordered
I have done a query that displays all the POs raised but it displays the PO
Number as many times as there are items on it
Can I do a query or a table that selects just the Po Number once from the
master table

yhanks
john

 

[Ryan]

In your query, find the data that is different on the items table, for
example the Item ID, and then remove that from your query. Then the next
step would be to add grouping, by right clicking in the query designer next
to one of your fields, and selecting Totals. This will allow you to group
data by PO Number.

 

[Klatuu]

No. A query will not show a PO once and all the items ordered on the PO. You
can present it that way using either a form or a report.

 

[JohnM]

Ryan

Tried deleting the items but my list still contains the same Po numbers
several times - When I select Totals all the boxes are completed with group
by - I have tried taking these out except the one for PO Number but that does
not work either

john

 

[JohnM]

Sorry maybe misleading you here

All I want is a list of the different PO Numbers - I do not need anything
else - I can delete the other info if required


john

 

[fredg]

Sorry maybe misleading you here

All I want is a list of the different PO Numbers - I do not need anything
else - I can delete the other info if required

john

If all you want is a list of the different PONumbers, with no other
data, then try:

Select Distinct TableName.PONumber from TableName Order By PONumber