Number Filed

[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

 

[Jerry Whittle]

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]

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.

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.

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