Help with removing duplicates in Query

[dsabot]

I have a query in access that is producing the following results:

OrderNumber QTY Product Price Product Cost FirstOfSumOfCost
431474 1 $10.99 $7.50 1.98
431475 1 $38.99 $17.50 3.28
431475 1 $17.99 $9.98 3.28
431475 1 $21.99 $0.00 3.28
431476 1 $6.99 $2.00 1.64


The query is displaying the same value for FirstOfSumOfCost if the OrderNumber repeats. I want it to show only the first instance of that field like I have below:

OrderNumber QTY Product Price Product Cost FirstOfSumOfCost
431474 1 $10.99 $7.50 1.98
431475 1 $38.99 $17.50 3.28
431475 1 $17.99 $9.98
431475 1 $21.99 $0.00
431476 1 $6.99 $2.00 1.64

Is there some formula or expression I need to make that happen?

 

[Lilliabeth]

Base a report on that query and hide the dupes there, not in the query.

--Lilliabeth