Next problem

[Ted Clore]

My fields that contain a general number round to the nearest whole number. It is only the fields that contain numbers, the fields that contain dollars will let me enter the decimal number, but the fields that are regular numbers won't let me.

What's the secret?

Ted

 

[tina]

check the Data Type of those "regular" number fields in table design view.
to enter numbers that include fractions, the data type must be Single or
Double - rather than Long Integer, Integer, or Byte.

btw, it's probably better to post plain text messages in these newsgroups,
rather than HTML.

hth


My fields that contain a general number round to the nearest whole number.
It is only the fields that contain numbers, the fields that contain dollars
will let me enter the decimal number, but the fields that are regular
numbers won't let me.

What's the secret?

Ted

 

[Guest]

Check your data type to see if you have the default on Number - Interger. If
so then change to Number - Single or Number - Double.

 

[Guest]

By field do you mean form control?
Go into the properties of the control and set the decimal plaves value.
If you mean a field in table design, it depends whether you made the column
an integer or not, if not you can specify the number of decimal places.
Obviously you wont get decimals if you display an integer no matter how many
decimal places you specify.
- Dorian

 

[Rick B]

Open your table in design-view and look at how that field is set up. Is it a "long integer"? Integers are whole numbers, by definition. They can not contain decimals. Change it to one of the formats that support decimals.

--
Rick B



My fields that contain a general number round to the nearest whole number. It is only the fields that contain numbers, the fields that contain dollars will let me enter the decimal number, but the fields that are regular numbers won't let me.

What's the secret?

Ted

 

[Ted Clore]

I have looked everywhere for the place that says long integer. There is
nothing in the Properties that says integer. I have went to the property
settings for the field in form design and change the field to "Regular
Number" with 2 decimal places, Fixed, and anything else that has to do with
numbers and changed them to different settings. Always I get a rounded
number.

Also, under Tools, Options, feature I have set that to number single and
then number double. Nothing changes, I always get a rounded number.

Whats the deal? I am totally baffled.

Ted



"Rick B" <Anonymous> wrote in message
Open your table in design-view and look at how that field is set up. Is it
a "long integer"? Integers are whole numbers, by definition. They can not
contain decimals. Change it to one of the formats that support decimals.

--
Rick B



My fields that contain a general number round to the nearest whole number.
It is only the fields that contain numbers, the fields that contain dollars
will let me enter the decimal number, but the fields that are regular
numbers won't let me.

What's the secret?

Ted

 

[Ted Clore]

I found it, thank you all for your help.

Count me as an Access dummy.

Ted