Parsing text and special characters before calculating?

[laxster]

I have a form/query in which people enter various data regarding what is on a pallet. For every item there is a default quantity which is pulled from a table. The quantities all include amounts like "50 lb. bags". I need do do a calculation based of the quantity of the items (IE there are 40 50 lb. bags). I would like for Access to make the calculation without anything that's not a number.

How would I build the query to ignore anything that's not a number in that particular field for the purposes of the calculation?

 

[jdraw]

I have a form/query in which people enter various data regarding what is on a pallet. For every item there is a default quantity which is pulled from a table. The quantities all include amounts like "50 lb. bags". I need do do a calculation based of the quantity of the items (IE there are 40 50 lb. bags). I would like for Access to make the calculation without anything that's not a number.

How would I build the query to ignore anything that's not a number in that particular field for the purposes of the calculation?

Take a look at the Val() function and see if it helps.
It deals with leading numerics in an alphanumeric string.