Importing excel data - sum amounts & tables are not related

I have 2 data imports from excel.
I am trying to figure out a way to combine these two data sets and show a SUM for each MONTH
but the tables have no relation between them (other than date fields)

How could i combine these two data sets and show a balance for each month?  

I have attached a file with the 2 separate imports.  I am looking for better ideas than the one I have.  Your help is appreciated.

thank you
pdvsaProject financeAsked:
Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this query

Select A.YearMon, Sum(A.SumAmount) As Total
SELECT Format([Net due dt],"yyyy mm") AS YearMon, Sum(ImportAP.[Amount in local cur]) AS SumAmount
GROUP BY Format([Net due dt],"yyyy mm")
Union ALL
SELECT Format([BegOfWeekDate],"yyyy mm") AS YearMon, Sum(ImportAR.ExpectedAmtRec) AS SumAmount
GROUP BY Format([BegOfWeekDate],"yyyy mm")
) As A
Group by A.YearMon
pdvsaProject financeAuthor Commented:
Very nice as usual.  I checked the numbers and it was spot on.   I thought the solution might have been a union.   I need to learn more about them.  thank you sir!
pdvsaProject financeAuthor Commented:
Rey,  I need to modify a bit and am about to post another question.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.