Search results

Hi All, I'm trying to update two columns (f13, f14) table based on a select statement. If I run the select statement on its own I get the desired results. Now I need to update those records. I get this error message when trying to run the code below. "You have written a subquery that can return...

Hello All, I'm working on a query in access 2003 that will check (records within the same table) to see if records are duplicated. Do I need to sort the table? If so I would sort it by FROM_ID, TO_ID, TRAN, PO#, INVOICE#, CTRL#. Here is an example of duplicate and non duplicate records...