Link to home
Start Free TrialLog in
Avatar of simplyss
simplyss

asked on

Query issue when key does not have both types of information in the table

I am using Access and need to add budget information together from 2 different tables in a query. Problem is the budget types are different and the stores that have the budget types sometimes have one budget type and not the other. When I combine the 2, only the stores that have both budget types show up in the query. If one store has a SAU Budget, but not a RES Budget, that store does not appear in the query. How do I fix this?
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of simplyss
simplyss

ASKER

SELECT tblPropertyAddresses.StoreNumber, tblCapExReserveBalance.ReserveBalance, qrySauPropertyAmounts.SumOfBudAmount, Nz([ReserveBalance])+Nz([SumOfBudAmount]) AS Expr1
FROM (tblPropertyAddresses INNER JOIN tblCapExReserveBalance ON tblPropertyAddresses.StoreNumber = tblCapExReserveBalance.PropertyNumber) INNER JOIN qrySauPropertyAmounts ON tblPropertyAddresses.StoreNumber = qrySauPropertyAmounts.StoreNumber;