how do you find and use the integer function in Access?

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

Guest

I need help. Can someone help me with this topic. I need to trunacate a
decimal with the integer function.
 
jda said:
I need help. Can someone help me with this topic. I need to trunacate a
decimal with the integer function.
Click to expand...
If your field is [Iamdecimal], just use Int([Iamdecimal]) or
Cint([Iamdecimal])
 
Or, if the values are really large, CLng().

Tom Ellison


Phil said:
jda said:
I need help. Can someone help me with this topic. I need to trunacate a
decimal with the integer function.
Click to expand...
If your field is [Iamdecimal], just use Int([Iamdecimal]) or
Cint([Iamdecimal])
Click to expand...
 
You must log in or register to reply here.

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

why do I get just the sum with Avg([column1]+[column2]...) 3
PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
Access stripping decimal places in query 1
Select Integers only 4
Need Monday date for given week number 4
MS word Find and Replace using Regex - Help required 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Multiplication in Query and Precision 1

Back
Top