Recent content by qzst66

Thanks for all the suggestions, but none of those seems to solve the issue. My goal is to have access indicate which records should be deleted. It shall not delete them automatically. It should only update that line with the word "Delete" if the PO number exists in the line or field below it...

Thank you for the advise but SELECT DISTINCT won't help much as I don't have a fields "delete" or "Keep" in my table yet.

Hi, I am new to access. I have a table with duplicate data i.e. column A has all the purchase order numbers, column B all the dates. I have sorted the table by purchase orders ascending and dates ascending. Now this table has duplicate records. Goal is to have only unique purchase order numbers...