trunc function

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
 
M

Michel Walsh

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Function like Excel TRUNC function? 2
trunc 1
equivilant to trunc function in access 6
Excel Repeating a RAND() function under certain conditions 0
Subquery rewrite from Oracle 1
Converting a GPS waypoint from decimal to degrees, minutes and sec 2
Work's on mine but not others 2
Tie a Calendar week to a Scoped Projected Week 3

Top