Trunc Function?

[PantoKing]

Hello,

Can anyone tell me the best way to recreate the Trunc function from Excel in MS Access.
I have a value that I need to truncate (not round!) in Access. I use the excel round function by referencing it using excel.worksheetfunction.round but Trunc doesn't seem to be available in the library. Anyone got any ideas?

Cheers,

Steve. Make things as simple as possible — but no simpler.

 

[GHolden]

Check out Int and Fix in the help they return just the integer part of a number (they deal with negative numbers differently is the only difference between the two).

There are two ways to write error-free programs; only the third one works.