Creating Expression for Sum of two fields
I'm assuming thisis on a form?
Try putting something like the following in the ControlSource property of
the text control that you want to display the sum in:
ControlSource: = NZ([Score A), 0) + NZ([Score B), 0)
--
HTH
Dale
Don''t forget to rate the post if it was helpful!
email address is invalid
Please reply to newsgroup only.
"Nirav" wrote:
Hi All,
I am new userof access and I am creating a for where I have two fields.
Ex. Score A (Combobox - 0, 1 or 2)
Score B (Combobox - 0, 1 or 2)
Total Score (Text Box) - (I want to create expression here so total score
automatically can be sum of score A and Score B.
Please Help
|