Number Filed

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I have a number field and I want to extract the digits to the left of the
decimal point. So that 10.7 would be 10. I do not want to round up at all.
How do I do this? Thanks, Sean
 
In a query, something like this with the proper field name.

Fixed: Fix([TheFieldName)

The Fix and Int functions do about the same thing except they handle
negative numbers differently. If you have any negative numbers, look up Fix
and Int in Help.
 
Whoop! There's a typo. It should be:

Fixed: Fix([TheFieldName])

Sorry about that.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Jerry Whittle said:
In a query, something like this with the proper field name.

Fixed: Fix([TheFieldName)

The Fix and Int functions do about the same thing except they handle
negative numbers differently. If you have any negative numbers, look up Fix
and Int in Help.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


Sean said:
I have a number field and I want to extract the digits to the left of the
decimal point. So that 10.7 would be 10. I do not want to round up at all.
How do I do this? Thanks, Sean
Click to expand...
Click to expand...
 
Back
Top