How do I create an Access query that will delete rows from a table based upon certain criteria?
Posted on 2011-09-21
I have a query that shows three fields: short ID, long ID and a count of the long ID. I also have a table that shows the same short and long ID fields and data. What I need is a query that checks the count number, if it is greater than 2 then the deletion query will remove data from the table based upon the short ID else if it is equal to 2 then it should be based on the long ID.
Hope you can follow the above,