How to Sum Combo Boxes in the Web App?

[patchesohouli]

I have a web app view, where users will make numeric selections from combo boxes. I need to show the sum of those values on the form itself. So after they make the selections from the drop-down, a field displays with the sum of those values. I’ve played around with queries and macros to get this simple formula down, and cannot get the result.
A simple expression using the “+” (comobox + combox 2) just concatenates the values, but doesn’t sum them. Please help! Thanks!

[zmbd]

Unfortunately I do not have a SharePoint server environment to test this out for you; however, from your last statement, it appears as if your control values are being treated as strings; thus, the concatenation instead of the addition.

In VBA there are the type conversion functions (link)and I suspect that you are going to have to use something along those lines to force the control string values to their numeric equivalent.

I fear that you most likely are going to have to do thus within the database side of the application and not the web-form

Sorry, I'll not be much more help here now that MS has forced the SharePoint server requirement.

-Z