I am using a query to compare 2 tables - lets say tblNewTransactions and tblTransactions where I am looking for records in the former that are not in the latter (because some definitely are).
The outputted records have a checkbox field. The idea was to be able select each of the checkboxes of the records outputted so I could then return to the tblNewTransactions and review the records whose checkboxes have been selected and then once satisfied import them into tblTransactions.
Problem is I cannot amend the results of the query. After doing a bit of research I discovered you cannot amend the results of a JOIN query and figured this is my problem.
Is there a way of achieving my objective of wanting to review the records not in tblTransactions. Am I going about this the wrong way?
Any help would be great.
The outputted records have a checkbox field. The idea was to be able select each of the checkboxes of the records outputted so I could then return to the tblNewTransactions and review the records whose checkboxes have been selected and then once satisfied import them into tblTransactions.
Problem is I cannot amend the results of the query. After doing a bit of research I discovered you cannot amend the results of a JOIN query and figured this is my problem.
Is there a way of achieving my objective of wanting to review the records not in tblTransactions. Am I going about this the wrong way?
Any help would be great.