I have a table that contains shipping records for the month of January. This table contains the serial number of the item sold which is unique, the customer name and the date it was sold. If a customer returned an order or one unit off of that order we put those items back in stock and resell them out. If they get sold out in the same month, January for example, it will show up on the report as many times as it was sold out. So, I can have one serial number show up on this report, that I upload as a table, multiple times with different customer and date information. The only record I need to keep is the one with the latest date. I have been manually deleting the records, which takes forever. Someone mentioned to me that they thought there was a max function that could help me but they didn't know how to do it.
Can someone be so kind as to walk me through this?
Thank you in advance.
Shannon