Sum Of All Numeric Values In A TextBox

[taber13]

I have a select box that stores the selected value in a textbox comma delimited. This select box also stores the numeric value (price) in another textbox comma delimited. I would like to know how to Sum all the values in a textbox that has only numeric values comma delimited.

 

[Pat Hartman]

Change the table design. NO column should contain multiple values! You need a second table so that the multiple items can be stored properly. Take a look at the northwinds.mdb and see the order and order details tables for an example of this type of one-to-many relationship.

 

[llkhoutx]

Unpack them with the instr() function and add them together.