How can I keep the table from rounding my number entry?

[Guest]

I have a number column set to standard with 2 decimal places, but it keeps
wanting to round my entry to the nearest whole number. I am wanting exact
decimals to 2 places. I don't see any setting's in the design view that would
change this. There has got to be a way...??

Thanks!
Bryan

 

[Al Campagna]

Bryan,
Check your table design. If that field is defined as Byte, Integer, or
Long, it can only hold whole numbers.
Try the Single Data Type with a format of...
#.00;-#.00;.00;.00
should do the trick.

--
hth
Al Campagna
Access MVP 2007
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

Is the field set to "long integer" ???????

Should be decimal

 

[Joseph Meehan]

I have a number column set to standard with 2 decimal places, but it
keeps wanting to round my entry to the nearest whole number. I am
wanting exact decimals to 2 places. I don't see any setting's in the
design view that would change this. There has got to be a way...??

Thanks!
Bryan

Change the data type. You have it set as an integer and integers are
.... well integers. Integers have no decimal part.

depending on the potential size of the numbers try single or double
types.

 

[Rob Parker]

Hi Bryan,

I suspect that your datatype is Number, with the default field size of Long
Integer. This will (as its name signifies) round any entries to an integer
(whole number) value. You will need to choose either Single, Double, or
Decimal as the field size. See the Help file for details on the number
range which each datatype/field size will accept.

HTH,

Rob

 

[Guest]

Days:IIf([DATE SENT TO PEB]=Is Not Null, DateDiff("d",[Date of Board], [DATE
SENT TO PEB]), DateDiff([Date of Board], Now()))

Is the statement I tried to input into the query under "Field" where the
"Total" is Expression. If I try to move elsewhere in the query, or try to
view the SQL statement, it says that "The expression you entered contains
invalid syntax. You may have entered a comma without a preceding value or
identifier" and then highlights the 'Is" in the "Is Not Null".

 

[Rob Parker]

This post doesn't seem to have anything to do with the rest of this thread.
If you are posting a new question, start a new thread, don't reply to an
existing one.

That said:

Days:IIf(Not IsNull([DATE SENT TO PEB]), DateDiff("d",[Date of Board], [DATE
SENT TO PEB]), DateDiff("d",[Date of Board], Now()))

In addition to the incorrect syntax for testing whether [DATE SEND TO PEB]
is null, your second DateDiff expression was also wrong.

HTH,

Rob

Days:IIf([DATE SENT TO PEB]=Is Not Null, DateDiff("d",[Date of Board],
[DATE
SENT TO PEB]), DateDiff([Date of Board], Now()))

Is the statement I tried to input into the query under "Field" where the
"Total" is Expression. If I try to move elsewhere in the query, or try to
view the SQL statement, it says that "The expression you entered contains
invalid syntax. You may have entered a comma without a preceding value or
identifier" and then highlights the 'Is" in the "Is Not Null".

Hi Bryan,

I suspect that your datatype is Number, with the default field size of
Long
Integer. This will (as its name signifies) round any entries to an
integer
(whole number) value. You will need to choose either Single, Double, or
Decimal as the field size. See the Help file for details on the number
range which each datatype/field size will accept.

HTH,

Rob