Home > IT Answers > Microsoft Windows > Total Balance for Concatenated Unique ID in Access and Excel
Roballen88
5 pts.
 Total Balance for Concatenated Unique ID in Access and Excel
Access, compare reconciliation balance unique identifier, Concatenate, 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 other data. Does anyone have any advice for this process? Thanks in advance for any help you can provide

Software/Hardware used:
Microsoft Access/Excel
ASKED: October 29, 2010  2:05 AM
UPDATED: October 29, 2010  3:31 PM
RELATED QUESTIONS
Answer Wiki:
Try a query like this: <pre>SELECT t1.identifier, SUM(t1.amount) FROM table_1 AS t1 GROUP BY t1.identifier HAVING (((Sum(t1.amount))<> SELECT SUM(amount) FROM table_2 WHERE identifier = t1.identifier)));</pre>
Last Wiki Answer Submitted:  October 29, 2010  3:31 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _