Total Balance for Concatenated Unique ID in Access and Excel

5 pts.
Tags:
Concatenate
Microsoft Access
Microsoft 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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following