How can fix it? any better idea please

[meenctg]

I have two table.
TblA(date,income,amountIncome)
TblB(date,cost,amountCost)

I have made two query for 2 tables sum of amount field.then
I have make final query for balance amount

Date,SumOfamountIncome,SumOfamountCost,balance

My question is when any one table has not record the query doesn't give result.

I wanna when any one table has one record or not record it will give result. Like

12/2/14 120 0 120
Or
12/2/14 0 12 -12
Or if not record in two tbl
12/2/14 0 0 0

How is possible or any better idea for fix this?

 

[vbaInet]

I don't understand you fully but I think you need the Nz() function:

Nz([COLOR="Blue"]FieldName[/COLOR], 0)

... then Sum under this field.

http://www.techonthenet.com/access/functions/advanced/nz.php

 

[CJ_London]

or have one 'transactions' table which shows income as positive and cost as negative