View Single Post
  #2  
Old September 29th, 2008, 07:10 PM posted to microsoft.public.access.tablesdbdesign
Dale Fye
external usenet poster
 
Posts: 2,651
Default 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