Adding Calculation Field to Form

T

tskb

I am trying to add a calculation field to a form in access. Trying to
calculate total number of cases ordered times total pounds per cases
with a grand total. The expression used is
=Sum([ORDER_CASE])*[JENPROD]![Gross Weight] but getting error message
The expression On Open you entered as the event property setting
produced the following error: The object doesn't contain the Automation

object 'JENPROD.'.
*The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure]
*There may have been an erro evaluatin the function, event, or macro.

Any help that can be provided would be greatly appreciated.
Thank you.
 
M

ManningFan

What are you doing here? Are you trying to sum something off a
sub-form? Is JENPROD the name of an object on your form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top