I am recieving #Name? when trying to add fields from separte form

[Guest]

I have been working on a simple database that will allow employees to log
hours, with mention of what type of work they have done, and generate reports
for each employee on a weekly basis showing their daily work breakdown.

I have been trying to do somthing very simple, and feel a little foolish for
having these problems.

I have several tables, 1 per day of the week. In form mode you can enter
your hours; a daily total appears at the bottom of the form, and is working
correctly.
I am now trying to generate a table and form that will take those daily
totals and add them to create a Weekly total.

When I create the expression, I recieve the message "#Name?" in the field....
Why?
Any ideas on what simple thing i am doing wrong here??

Please inform.

 

[Guest]

Your question provides too little information for me to offer an informed
opinion, but as a guess you could try combining the tables with a query and
basing the form on that, perhaps with the total being a calculated field in
the query. However, the fact that you have a spearate table for each day of
the week suggests that your database structure needs a close look.
Questions: What is the structure of your database, including table
relationships? When you write "When I create the expression", to what
expression do you refer? Why have you decided to use separate tables for
each day of the week, and what information do you enter into those tables?