Delete records (1 Viewer)

[Philmore]

I have a table in acces which is actually a transaction history report file from an accounting program. It contains all the transactions for the last business week. I need one transaction for each item where the cost is different. eg.
I have ten transactions for the item chicken breast. of the ten transactions there are three items with a cost of $1.48 two with a cost of $1.35 and five with a cost of $1.40 I need to print a report with only one transaction from each of these groups of costs. I want to either delete the ones I don't wan't or move the ones I want to a new table. I need some help urgently.

 

[Pat Hartman]

If you don't need to print any specific information about the transaction except the product and cost, you can create a totals query that groups by the fields you want to see. You could also include a count if you want.

Select Product, Cost, Count(*) As TranCount
From YourTable
Group by Product, Cost;