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 MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text field to a Numeric field with a decimal

Status
Not open for further replies.
hawg9

hawg9

IS-IT--Management
Nov 9, 2005
22
US
I have a text field (0000000.00000) and I need to convert it to a numeric field. I have tried Int(Field Name) and set the properties to Fixed with a decimal value of 5. When it converts, it places all 0's after the decimal point.
 
Sort by date Sort by votes
that's because INT means integer and an integer can't have a decimal. You need to use a double or a float to get the decimal.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
618
rashmibala
R
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
982
strongm
strongm
C
  • Locked
  • Question
Query expression negative to a 0
Replies
6
Views
493
dhookom
dhookom
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
685
mikrom
mikrom
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top