Hey all,
I think I have a simple one, but I'm not really proficient in Access.
I have a table, where a column could produce "P" or "T" values. I want to run a query that gets rid of all "P" values. I thought I was on to something when the query asked "are you sure you want to delete 2 records?," so I was excited! When I returned to the table, I saw that the 2 rows itself says #Deleted in every cell, and I was hoping it would just remove the rows.
Is there a way that I can get a query to remove rows with "P" values and keep the Record ID in sequential numbering to identify the row #?
Thank you!
Bookmarks