Decimal Points

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I drop the decimal point section of a field in a query form or table.
Example:

6.8 to look like 6
3.2 to look like 3

I don't want to perform the rounding off of a number. I just want to drop
the right side of the decimal. I appreciate all the help you can give me.

TY
 
hi,
6.8 to look like 6
3.2 to look like 3

I don't want to perform the rounding off of a number. I just want to drop
the right side of the decimal. I appreciate all the help you can give me.
Click to expand...
Take a look at

CInt(), Fix and Int()

in the help.


mfG
--> stefan <--
 
hi,
If the field is call "text34", how do I apply the Cint or INT function?
Click to expand...
When you say "field", what do you mean: a control on a form or a real
field in a query or table?

In a query the SQL must look like that

SELECT CInt([text34]) AS cutField
FROM


or in a TextBox

"=CInt([text34])"



mfG
--> stefan <--
 
Back
Top