trunc

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

Guest

I have a number 24.50. I'm trying to get the trunc of this value...no
rounding (24) via a query. I couldn't find an excel equivalent for "trunc"
in access. Anyone tell me what it is? thanks
 
I have a number 24.50. I'm trying to get the trunc of this value...no
rounding (24) via a query. I couldn't find an excel equivalent for "trunc"
in access. Anyone tell me what it is? thanks
Click to expand...

Exp:Fix([FieldName])
 

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

equivilant to trunc function in access 6
trunc function 1
Formula converts a value to Feet Inches and fractions of an inch 1
Subquery rewrite from Oracle 1
Converting a GPS waypoint from decimal to degrees, minutes and sec 2
problem with round down 5
How do you randomly assign numbers without getting duplicates? 6
week numbers 3

Back
Top