Very Old Paradox/Object Pal use Very New to Access. Need help on getting totals

[goakley]

I used to be very comfortable with Paradox and Object Pal. I have not used it in years (Not even sure it still exists). I am trying to make a form with an employee information table (one) and the daily production of that employee (many). I need totals of several fields from the production table, but every time I try it just returns "error". I have used a text field and added the expression and placed it in the footer of the field. I know this is a really beginner question and am embarrassed that I have to ask it, but, what am I doing wrong?

The employee table is keyed off the employee ID.
The production table has the employee ID along with every day of production information which includes volume and hours. The production table carries a years worth of information. I need to know the total hours and volume an employee has done. I have set the relationship up.
Thanks

[pbaldy]

You've said you've "added the expression" but haven't told us what it is. If the data is on the form, a textbox with

=Sum(FieldName)

in the form footer should sum the data.

[goakley]

You've said you've "added the expression" but haven't told us what it is. If the data is on the form, a textbox with

=Sum(FieldName)

in the form footer should sum the data.

Sorry, I am new at forums also.

One of the fields I need totaled is the "Reviews" field. It is a field in the subform. In the form footer area I have added a text box with the expression
=sum([reviews]).

[pbaldy]

No worries. You have that in the form's footer, or the subform's? It would need to be in the subform's. You can refer to that from the main form if you want to display it there. For example:

http://office.microsoft.com/en-us/ac...005187909.aspx

[goakley]

No worries. You have that in the form's footer, or the subform's? It would need to be in the subform's. You can refer to that from the main form if you want to display it there. For example:

http://office.microsoft.com/en-us/ac...005187909.aspx

Thank you! Thank you!

[pbaldy]

Worked? Happy to help, and welcome to the site by the way!