I recently acquired Access 2007. I'm having a problem with my currency fields. When entering a number with a specific decimal figure, it rounds the figure to the nearest whole dollar. How do I correct this to display what I entered?
Advanced Beginner
Windows Vista 
Access 2007
Currency Problem
I recently acquired Access 2007. I'm having a problem with my currency fields. When entering a number with a specific decimal figure, it rounds the figure to the nearest whole dollar. How do I correct this to display what I entered?
Administrator
Windows XP Access 2002
It sounds like your fields are Integers (short or long) rather than Currency.
Posting Permissions
Reply With Quote