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!

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

Type conversion

Status
Not open for further replies.
fayna

fayna

Programmer
Jan 14, 2002
35
ES
Hi,
I need to convert a text field into a numeric field.I've tried to use 'CONVERT' but I get an error.
How can I convert data types?

Thanks
 
Sort by date Sort by votes
Have a look at the Int and/or Val functions

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Thanks a lot!It worked with val function :-D
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

irethedo
  • Locked
  • Question
Is there an easy way to add the sum of a certain type of record to each record of that type? 2
Replies
8
Views
52
irethedo
irethedo
Aximboy
  • Locked
  • Question
Data type mismatch
Replies
1
Views
33
dhookom
dhookom
Statistician
  • Locked
  • Question
Data type mismatch - vba function in query 1
Replies
3
Views
51
Statistician
Statistician
Darrylles
  • Locked
  • Question
Incorrect data-type with Access pass-through make-table query
Replies
2
Views
27
Darrylles
Darrylles
PWD
  • Locked
  • Question
Arithmetic overflow error converting expression to date type datetime (#8115)
Replies
0
Views
44
PWD
PWD

Part and Inventory Search

Sponsor

Back
Top