Any MS Access gurus here?

[Doomer]

Gotta stupid question. Don't know the answer so I gotta ask.

How the heck do i get a table to store and display decimals? No matter what I do, 44.43 turns into 44. I can't get the decimal to show in a form either. I know the answer has to be simple but i can't figure it out.

TIA

 

[mugs]

Change the field type from Long Integer to Double

 

[Doomer]

Cool, thanks.

Should it be single of double? What's the difference?

btw: This is a 2 decimal place field. It's not currency, it's weight.

 

[mugs]

Double can hold larger numbers and more precision. You probably only need a single.

 

[Doomer]

Thanks. Think I'll change it to double while I can. There's no data in it yet.

 

[EagleKeeper]

There is also a display option that has number of decimal places to display.

 

[Doomer]

Originally posted by: EagleKeeper
There is also a display option that has number of decimal places to display.

Yep, I tried every one I could find and they all did nothing. Don't understand why they are there but what do I know, lol.