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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rounding Numbers In An Access Query

Status
Not open for further replies.
bwedmund

bwedmund

Technical User
Oct 29, 2000
17
US
I have queries written in access that are averaging daily, monthly, quarterly, and yearly totals. On my averages, the totals are not rounding to the nearest whole numbers. Is there a way to get the queries to round off the numbers to the nearest whole number.

Thanks;

bwedmund
 
Sort by date Sort by votes
You can use the Round function specifying 0 as the second parameter. eg. Round([fieldname],0)

Neil

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Xavierparkash
  • Locked
  • Question
MS Access Slow Search in Linked Database
Replies
0
Views
151
Xavierparkash
Xavierparkash
leifoet
  • Locked
  • Question
How to store decimal numbers in an Access database?
2
Replies
27
Views
529
Andrzejek
Andrzejek
caykamanj1966
  • Locked
  • Question
Available Numbers
Replies
1
Views
97
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
205
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Running query with parameter from Inputbox 2
Replies
8
Views
280
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top