[AccessD] add numbers

Hello,

these values are headshield patterns of snakes.
Let me explain:
the value 2(2ma) means: 2 shields front + 2 shields middleback (ma =
middenachter in Dutch which means middleback in English).

I need the total number of shields. In my example 2+2 = 4

I'll hope somebody can help me on this.
The example above is of one kind of scale, i need to extract seven kind of
scales for each animal, an i have data from about 4500 snakes.

Thanks

Pedro

----- Original Message -----
From: "Susan Harkins" <ssharkins at bellsouth.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Monday, April 11, 2005 11:35 PM
Subject: RE: [AccessD] add numbers


> It looks to me like he needs to extract all the numbers in a given entry
and
> add them. Not an easy feat.
>
> Susan H.
>
> Hi Pedro,
>
> Could you give more information?  Also, could you elaborate on how your
> equations are working?
>
> Dan Waters
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
Sent: Monday, April 11, 2005 3:59 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] add numbers

Hello Group,

i have a table with a field [Para], that has values like:

2(2ma)
3(0v)
2(2v+2a)

what i would like is the total of numbers of field [Para],
as result in a new field [Para_total].

the result would be

4                  2(2ma)    = 2+2
3                  3(0v)        = 3+0
6                  2(2v+2a) = 2+2+2

Thanks

Pedro Janssen