Total Balance for Concatenated Unique ID in Access and Excel
Hi, I have two spreadsheets that I import in to MS Access to compare. To get a comparable Unique Identified, I concatenate the data in three columns to one unique reference. I then want to find the total balance for each identifier, which normally have around 8 entries each and then compare it against the [...]

Answer Question   |  October 29, 2010  2:05 AM
Access, compare reconciliation balance unique identifier, Concatenate, excel