Access 2003 - Currency format problems

[mariee4]

I have formatted my field to currency and it always rounds up to the nearest
dollar but i need to include cents. i've tried changing the amount of decimal
places but nothing seems to work. thanks in advance!

 

[Al Campagna]

Marie,
Make sure that your field is defined as Numeric - Single or Double.
If it's Byte, Integer, or Long Integer, it will not accept decimal values.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."