Numeric formatting in Access 2003

P

Pemmom

I have created an access database. There are several fields that are
formatted as currency, with two decimal places. When I enter say - 4.22, it
displays 4.00, NOT the .22. My total field doesn't bring forward the .22
either. WHAT am I doing wrong?? HELP
 
J

Jerry Whittle

Check the data type for those field at table level. I bet that they are
integer or long integer. By definition, integers don't have decimals.

Something to remember in Access: formatting is how it looks, not how it's
stored.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
How do I stop Access from rounding Numeric Fields? 2
Is there a way of not showing zero totals in a pivot table? 2
Number format - two many Decimal places???? 3
Preventing rounding numbers to nearest dollar 2
Designing Access tables 3
Decimal Places aren't copying into Access from Excel 1
The sum of 2 fields in an access table 2

Top