Duplicates

[Gaetanm via AccessMonster.com]

I have a query which gives me in part the [JobNumber] and [PurchaseID]. What
I cant seem
to be able to figure out is the following:

If multiple records where [JobNumber] and [PuchaseID] are the same just show
me one record
plus the other other records

Any Ideas?

Below is my present SQL:

SELECT MYOB_Items.ItemName, MYOB_Items.ItemNumber, MYOB_Jobs.JobNumber,
MYOB_Purchases.TaxInclusiveFreight, MYOB_Purchases.PurchaseID
FROM ((MYOB_ItemPurchaseLines INNER JOIN MYOB_Purchases ON
MYOB_ItemPurchaseLines.PurchaseID = MYOB_Purchases.PurchaseID) INNER JOIN
MYOB_Items ON MYOB_ItemPurchaseLines.ItemID = MYOB_Items.ItemID) INNER JOIN
MYOB_Jobs ON MYOB_ItemPurchaseLines.JobID = MYOB_Jobs.JobID
WHERE (((MYOB_Purchases.TaxInclusiveFreight)>1));


Gaetanm

 

[KARL DEWEY]

If multiple records where [JobNumber] and [PuchaseID] are the same just show
me one record plus the other other records
Please restate your requirement as I do not understand the above statement
as written.
Better yet would to post some sample data and what you want the result of
the query to produce from that data. Include table and field names and data
type.