Calculation Result in field

CSJM45

Registered User.
Local time
Yesterday, 23:18
Joined
Aug 7, 2013
Messages
45
I'm trying to multiply the values of two number fields together, but it is not working. I used to be able to do this easily in earlier versions of Access. Here's the problem:

On the form, I need field A x field B to appear in field C. I've tried this as an expression in the build event function on the control, but it is not working. My code reads as follows: = (field A) * (field B).

Thanks, in advance, for the help.
 
Hmm, swap out the parenthesis for brackets, that should do it.
 
Or just enter

=[Field A]*[Field B]

in the control source of Field C.
 
Problem solved. I ended up changing the table field to a calculated control.

Thanks, everyone, for your help!!:)
 

Users who are viewing this thread

Back
Top Bottom