Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you add numbers in a text field?

Status
Not open for further replies.

pmo

Technical User
Jan 15, 2001
76
0
0
AU
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...

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

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me
 
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
 
fine

Zameer Abdulla
[sub]Jack of Visual Basic Programming, Master in Dining & Sleeping[/sub]
Visit Me
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top