trunc function

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

Guest

Hello All

Excel has a trunc function which I can't find in access. I tried help and the access group on the xp assistance site and couldn't find anything related. I have a basic understanding of access, but am not a wizzard. Is there a way to use the trunc function in a query in a formula

Thank you for all answers

Chris
 
Hi,


If trunc means truncate, I assume Int( ) would do, unless you prefer
Fix( ). Int ant Fix behavior differ for negative argument.



? Int(4.9), Fix(-4.9), Int(-4.9)
4 -4 -5


so Int is the FLOOR function.



Hoping it may help,
Vanderghast, Access MVP


chrisfree said:
Hello All,

Excel has a trunc function which I can't find in access. I tried help and
Click to expand...
the access group on the xp assistance site and couldn't find anything
related. I have a basic understanding of access, but am not a wizzard. Is
there a way to use the trunc function in a query in a formula?
 
Back
Top