Search results for query: *

Dear Stella I do need the field because it is the identifier for the branch concerned. The problem occurs when both branches keyed in the exact details of a payment made to update their records. This is not supposed to happen if the client follows the procedure of exchanging updated data...

Dear Mike and Stella Thanks for the insightful solutions. Removing the "offending" field is the probable solution since in combining the records, what is important is keeping the payment records with the exact date, amount paid, receipt number etc from being duplicated so as to have an...

Dear Dave The actual fields in the table are many. What needs to be excluded is only one field. I am not too familiar with using SQL commands which may be peanuts to you guys. Any guidance is appreciated.

Hi all I have two tables from two different branches that i need to combine while at the same time remove any duplicates. I used the following SQL statement: Select * From table1 Union Select * From table2 Into Table MERGED2 However, some duplicates are not removed by virtue of having one...