Hi,
I usually import rows of data into a blank table in Access, once every day for further processing. Unfortunately this data may also contain invalid rows and/or the ones that I have processed before. I want to sort the data here and move them into 3 other tables; Accumulated, Latest and Rejected.
Accumulated contains list of rows that have been processed at one time. Latest contains rows which are not found in Accumulated, meaning data that would be transferred to this table are fresh for that day. Rejected table shows rows which do not meet a criterion, that is having 3 or 9-digit ID number instead of the correct 6-digit.
To save time, how do I create a macro or button that would ask Access to automatically scan the rows in the blank table, sort and then move them into the 3 different tables depending on what they represent?
Highly appreciated. Thank you in advance.