help with adding in expressions

[smcglone]

Hi,
I am building a form with multiple combo boxes. Each has a list of numeric
choices. I need to get a total of all of these for a 'grand total' for a
individuals score. When I use the expression builder, instead of returning
the total of the boxes, it strings all the numbers together. I have been
though all of the office help and read other posts and tried multiple things
and nothing seems to work. Any help would be great!!
Thanks!

 

[Al Campagna]

smcglone,
That's due to the data being text, rather than numeric.
Try...
= Val(cboOne) + Val(cboTwo) ...etc
or
Val the data in the combo RowSource query.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[smcglone]

Thank you so much!! It works now!

smcglone,
That's due to the data being text, rather than numeric.
Try...
= Val(cboOne) + Val(cboTwo) ...etc
or
Val the data in the combo RowSource query.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."