Using MROUND or ROUNDDOWN in MS Access 2000

[Ranger1]

I need to perform some rounding operations in a select query in MS
Access 2000, but it does not seem to accept the call of the functions
RMOUND() or ROUNDDOWN(). Can these functions be used in MS Access?
I know they work in Excel, but I'm trying to round part quantity data on
some 200k records to the nearest 100 pieces and it would be a lot easier
to work with the records in access instead of excel.
Any suggestions??

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Brian]

"Ranger1" <ra*****@devdex.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

I need to perform some rounding operations in a select query in MS
Access 2000, but it does not seem to accept the call of the functions
RMOUND() or ROUNDDOWN(). Can these functions be used in MS Access?
I know they work in Excel, but I'm trying to round part quantity data on
some 200k records to the nearest 100 pieces and it would be a lot easier
to work with the records in access instead of excel.
Any suggestions??

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

No, those functions don't exist in Access. Look up the Round function in
Help. This might also be useful:

http://support.microsoft.com/default...b;en-us;209996

[Ranger1]

The link to the KB article on rounding did the trick. Thanks a lot !!
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!