I am setting up a database with 2 number fields. I will need to do calculations with these numbers later. I have them set as fixed with 2 decimal places. Everytime I enter data into the fields, it rounds them up or down to whole numbers. How can I get this to stop?
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!
Fields keep rounding?
- Thread starter detwings9
- Start date
It sounds like you might have the field in your table set as an Integer. Check the table and change it to single or double if that is the case.
DBAMJA
It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.
DBAMJA
It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question