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

B

Bryan

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
 
R

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
 
D

DandimLee

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".
 
R

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

DandimLee said:
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 said:
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
Click to expand...
Click to expand...
 
Top