How do you add numbers in a text field?

[pmo]

My field is set as text as depending on the entry a number or a letter may be entered.
I would like to run a query that adds the numbers together for a particular field.
Thanks for your help...

 

[ZmrAbdulla]

Can you provide some sample data, how the data to be appeared after the query ??

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[pmo]

Zameer,
Thanks for offering your help.
I may have sorted out the problem.
My field was a mixture of numbers and letters. When I attempted to add there was a mismatch because of the numbers and text entered. I have filtered just to include the numbers and it is now happy to add up.

Thanks anyway.

Wayne

 

[ZmrAbdulla]

fine

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me