D Donald Sweat Jun 4, 2005 #1 If I want to calculate field3=field2*field1 before the record is saved on a form, what is the best way to do this? Thanks, Donnie
If I want to calculate field3=field2*field1 before the record is saved on a form, what is the best way to do this? Thanks, Donnie
F fredg Jun 4, 2005 #2 If I want to calculate field3=field2*field1 before the record is saved on a form, what is the best way to do this? Thanks, Donnie Click to expand... As control source of an UNBOUND text control: =[Field2]*[Field1] The result of the calculation will appear on the form... but is NOT saved, nor should it be saved, in a table. Any time you need the result of [Field2]*[Field1], simply recalculate it, as above.
If I want to calculate field3=field2*field1 before the record is saved on a form, what is the best way to do this? Thanks, Donnie Click to expand... As control source of an UNBOUND text control: =[Field2]*[Field1] The result of the calculation will appear on the form... but is NOT saved, nor should it be saved, in a table. Any time you need the result of [Field2]*[Field1], simply recalculate it, as above.
G Guest Jun 8, 2005 #3 thank you. I needed this.. I was putting my expression in the incorrect spot. This really helped. -- Sandie Hetland Ephesians 2:1 fredg said: If I want to calculate field3=field2*field1 before the record is saved on a form, what is the best way to do this? Thanks, Donnie Click to expand... As control source of an UNBOUND text control: =[Field2]*[Field1] The result of the calculation will appear on the form... but is NOT saved, nor should it be saved, in a table. Any time you need the result of [Field2]*[Field1], simply recalculate it, as above. Click to expand...
thank you. I needed this.. I was putting my expression in the incorrect spot. This really helped. -- Sandie Hetland Ephesians 2:1 fredg said: If I want to calculate field3=field2*field1 before the record is saved on a form, what is the best way to do this? Thanks, Donnie Click to expand... As control source of an UNBOUND text control: =[Field2]*[Field1] The result of the calculation will appear on the form... but is NOT saved, nor should it be saved, in a table. Any time you need the result of [Field2]*[Field1], simply recalculate it, as above. Click to expand...
