Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Roundation Function

Status
Not open for further replies.
mtomar

mtomar

Programmer
Jun 24, 2002
10
0
0
US

Hi,

After created query or access report, I want a good function to round figure in calculated field x*y/z

I used function "round", but did not give me exact amount.

Thanks.

mtomar@msn.com
 
Sort by date Sort by votes
Try the CInt() function and see if that meets your needs.

Example:
x = 4.33
? CInt(x)
4

x = 4.83
? CInt(x)
5
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JackSapsford
  • Locked
  • Question
Microsoft Access 2000 - Function Is Not Available...
Replies
12
Views
92
combo
combo
bobjackson
  • Locked
  • Question
Count function
Replies
2
Views
42
dhookom
dhookom
Moss100
  • Locked
  • Question
Writing a function loop through a settings table and set TempVars 2
Replies
9
Views
73
Andrzejek
Andrzejek
bdmoran
  • Locked
  • Question
Access function to round time to quarter hour
2
Replies
28
Views
178
MajP
MajP
jahnell
  • Locked
  • Question
mde and accde of database will not function
Replies
1
Views
40
jahnell
jahnell

Part and Inventory Search

Sponsor

Back
Top