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 Rhinorhino 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
Joined
Jan 14, 2002
Messages
35
Location
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

combo
  • Locked
  • Question Question
SQL data types in CREATE/ALTER TABLE queries
Replies
2
Views
3K
combo
combo
irethedo
  • Locked
  • Question Question
Is there an easy way to add the sum of a certain type of record to each record of that type?
Replies
8
Views
409
irethedo
irethedo
Aximboy
  • Locked
  • Question Question
Data type mismatch
Replies
1
Views
199
dhookom
dhookom
Statistician
  • Locked
  • Question Question
Data type mismatch - vba function in query
Replies
3
Views
284
Statistician
Statistician
Darrylles
  • Locked
  • Question Question
Incorrect data-type with Access pass-through make-table query
Replies
2
Views
180
Darrylles
Darrylles

Part and Inventory Search

Sponsor

Back
Top