Hi everyone,

I have an issue using MSAccess 2003 i have a query with a calculated 
field and this field is set to currency.

If the final result ends in .5 it rounds down and i need it to round 
up for instance

892.5 = 893
892.4 = 892

Using the Round() it will truncate and and reflect a round down 
instead of a proper round.

Any help would greatly be appreciated.

Thanks
Eileen






 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/ms_access/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to