How to join these 4 tables with query?

[d_profesor]

I have four table:

tblTempRunningCash
Field are : Date, CashBalance

tblTempRunningInvValue
Field: Date, InvBalance

tblTemRunningReceivable
Field: Date, RecBalance

tblTempRunningPayable
Filed: Date, PayBalance

My objective is : I want to display from those table in a report or form a report table that contain CashBalance, InvBalance, PayBalance, and RecBalance in a month. Something like picture in attachment file.

so, what i have to do ? Can i create a query to join that four table? any suggestion please..

Thanks

 

[speakers_86]

I don't believe any of these values should be stored in a table. They can all be calculated in a query.

 

[d_profesor]

I don't believe any of these values should be stored in a table. They can all be calculated in a query.

Thanks for your respond...

yes, i think so.. but i don't know which query i must use for this purpose.

Maybe my explanation is insufficient. Sory, My english is bad . But i'll try to make it clear for you.

I've create 4 temporary tables that stored running balance for cash, Inventory, receivable, and payable balance. For each tables, data are filled through a code that i've created. So, when i click a button, these tables are updated, and this step's done. But then i need to show the data in a 'report' with appearance look like in attachment file. the problem is don't know how join these 4 temporary tables. Can you give me any direction to do it? if it's a query, what query?

thanks again..