How do you have decimal points in Access field

[sarber72]

I have an end user that has a OEM office product and wants to know how to have 2 decimal points in a field. She is trying to use Access as an inventory/po database and she needs to have one field w/ decimal points. Any suggestions?

Cheers,
Shannon

 

[Dreamboat]

In the field in the table's design view:

Make sure data type is Number
Make sure format is correct by choosing it from the dropdown. Anne Troy

http://www.TheWordExpert.com

http://www.Brainbench.com

 

[TomCologne]

You will have to set the "Field Size" to "Single" or "Double" since "Long/Integer" will still not return the decimal despite the "Number" and "Decimal" settings.

You're not alone,

TomCologne