I do not want round up numbers

S

sronaz

I am a new access user. I don't want the numbers to round up. I have tried changing the field to fixed. currency, general number, just about everything. The field is linked to another table. I need my numbers to show 13.50 not 14.00.
Can someone please help me?
 
V

Van T. Dinh

It sounds to me that you changed the Format of the number, NOT the size of
the number. In the Table DesignView, select the required Field and look for
the Field Size in the lower left pane. You probably selected Long or
Integer which can only store whole numbers.

If you want to store decimal numbers, you need to select Double or Single or
Decimal in the Field Size.

--
HTH
Van T. Dinh
MVP (Access)



sronaz said:
I am a new access user. I don't want the numbers to round up. I have tried
changing the field to fixed. currency, general number, just about
everything. The field is linked to another table. I need my numbers to show
13.50 not 14.00.
 

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

Top