Try this: Format([mycurrency],"$0")
John V. Ruff - The Eternal Optimist :-)
"Commit to the Lord whatever you do,
and your plans will succeed." Proverbs 16:3
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of eileen1309
Sent: Monday, January 30, 2006 4:28 PM
To: [email protected]
Subject: [ms_access] help with rounding to nearest dollar
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
SPONSORED LINKS
Microsoft
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+
access+database&w2=Database+development+software&w3=Database+management+soft
ware&w4=Database+software&w5=Inventory+database+software&w6=Membership+datab
ase+software&c=6&s=190&.sig=hc7Za8QzEj1t7F8GW0yzhA> access database
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Micros
oft+access+database&w2=Database+development+software&w3=Database+management+
software&w4=Database+software&w5=Inventory+database+software&w6=Membership+d
atabase+software&c=6&s=190&.sig=i5H8GCn7HzmglwpvhJg19w> development
software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Microso
ft+access+database&w2=Database+development+software&w3=Database+management+s
oftware&w4=Database+software&w5=Inventory+database+software&w6=Membership+da
tabase+software&c=6&s=190&.sig=kzlRmjQuUTEFLTjkEd6-kg> management software
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+access+d
atabase&w2=Database+development+software&w3=Database+management+software&w4=
Database+software&w5=Inventory+database+software&w6=Membership+database+soft
ware&c=6&s=190&.sig=CoCmr_EubT5Xd83NiQjcpg> software
Inventory
<http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Microsof
t+access+database&w2=Database+development+software&w3=Database+management+so
ftware&w4=Database+software&w5=Inventory+database+software&w6=Membership+dat
abase+software&c=6&s=190&.sig=DHnS8Uu1ImyGVg1J4k0BMw> database software
Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Microso
ft+access+database&w2=Database+development+software&w3=Database+management+s
oftware&w4=Database+software&w5=Inventory+database+software&w6=Membership+da
tabase+software&c=6&s=190&.sig=uEGHlFpqbscHu8mCHe7tzg> database software
_____
YAHOO! GROUPS LINKS
* Visit your group "ms_access
<http://groups.yahoo.com/group/ms_access> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
_____
[Non-text portions of this message have been removed]
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/
