Reconcile two sets of data without a unique field.
I have two data sets that have account number and dollars. There are duplicate account numbers and dollars as this is a batch of credits interfacing with another system. I need to reconcile the first set to the second set. So in think it is something like this, if account number and dollar in set one match account number and dollar in set two then enter 1. Hope this makes sense.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 24, 2009 9:20 PM
UPDATED:
April 4, 2009 5:16 PM
Answer Wiki:
I'm not sure I understood exactly what you mean but I guess you'd like to eliminate duplicate entries in a recordset; if this is the case just change your <b>SELECT </b>to <b>SELECT DISTINCT</b>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
