Thread: Form for multiple tables and queries

I made an entry form with the wizard
It has all the fields for for entry
I have queries process that information and I would like to have it read back on this form. I understand that the query will not automatically update to subsequent information so I imagine I will enclose a button "Save and Recalc" that will rerun the query with this need infomation

Example

Table
Date
Income
Expenses

Query
average income 180 days

I want that to be featured on the form. how do i make it available

the text box only allows me to display info from the table. How do I open it up to other things?

This is in addition to the post above

This is the sample of the database that I am making. I want to query the checking and then read out on the entry form the current tally