Form contant not showing without both table entries

[meenctg]

Descriptions:
I have two table. One for sell entry another is Cost
I have created three query
1. Sum of sell today
2. Sum of cost today
3. balance today
(For better understanding I have attached my DB)

Problem:
I have filled some record in sell table. But not in Cost.
When i run the query/Form of todays balance. It shows nothing (blank). But when i filled both table its show result

What i wanna?
I wanna, if i entry only sell table today (Not entry in cost)
it'll show
SumOfToday's sell : 120$ (or any amount)
SumOfToday's cost: 00$
Today's balance: 120$

If is it possible please anybody help me.

 

[John Big Booty]

As it stands you are linking on Date and as presented there is no data in your Table CostCount. Therefore there are no matching records to select in your query and it comes up blank. I have added a zero value record for Today and your query should now work.

 

[meenctg]

As it stands you are linking on Date and as presented there is no data in your Table CostCount. Therefore there are no matching records to select in your query and it comes up blank. I have added a zero value record for Today and your query should now work.

Thnaks for response!
Actually i had a wrong. I Have attached another time by proofing.

I can do it and also i know that but i wanna without inserting a record in cost table i wanna output.

I know that if i insert a zero value in cost table i'll get output.

Is there any way without inserting table in cost table can i get output?

 

[John Big Booty]

Without a matching record to link to you will always get a null result.