Query total by month (1 Viewer)

[foshizzle]

Im sorry, I just dont see how to put this together. i see what you meant about the calculation fields..

This is what i keep wanting to do based on the field names of the 3 queries..

expr1: ([TotalChecks] - [qryBlotter2]![TotalChecks] )

But it keeps prompting me for the qryblotter2 totalchecks..

Right now Im using simple subtraction to ensure Im hitting the correct fields/queries..

 

[namliam]

Exchange the ! for a .

If you are unsure of the proper syntax, try right clicking on the field and choosing the "build" or "Expression builder" or something simular option. With simple clicking you can then get the proper syntax.

SELECT qryBlotter1.*, qryBlotter2.*
     , [qryBlotter1].[TotalChecks]-[qryBlotter2].[TotalChecks] AS Expr1
FROM qryBlotter1 LEFT JOIN qryBlotter2 ON (qryBlotter1.PrevYear = qryBlotter2.Year) AND (qryBlotter1.PrevMonth = qryBlotter2.Month);

 

[foshizzle]

Perfect. I see what you mean now. flawless. thanks so much!
ill update other link here too - was t sure if i needed a new thread for the last question. thanks agin!