Deleting a duplicate record without deleting the data related.

[Guest]

tableI created a query to link an open receipts table to an open receivables
by serial number. When I run the query, my out put shows the same receipt
number each time a unique invoice with that serial number is found. Is there
any way to delete or clear the duplicate receipt number without losing each
invoice that is related to that invoice? I only want to see the receipt
number once with a list of related invoices.

 

[Joseph Meehan]

You should be able to do that in a report, but I am not sure you can do
that in a query.

 

[Guest]

How can I do that with a report?

HMW

You should be able to do that in a report, but I am not sure you can do
that in a query.

 

[Joseph Meehan]

In short you group of the filed you want, like serial number.

You add the serial number field to the group heading and put the detail
you want to see in the group detail area.