Can't save decimal numbers

[Guest]

Ok, I know this sounds bizarre and I regret to say it has me baffled. New
decimal fields in tables will accept entry of decimal numbers but
immediately change same into integers.

Can someone please tell me what incredibly silly thing I'm doing to cause
this???

Thanks

[Bas Cost Budde]

Re: Can't save decimal numbers

You probably have an integer field.
You have to both set the type to numerical, and the subtype to either
Single or Double (precision floating point). Numerical defaults to Long
(integer)

lorendi@interne t.com wrote:[color=blue]
> Ok, I know this sounds bizarre and I regret to say it has me baffled. New
> decimal fields in tables will accept entry of decimal numbers but
> immediately change same into integers.
>
> Can someone please tell me what incredibly silly thing I'm doing to cause
> this???
>
> Thanks[/color]

--
Bas Cost Budde, Holland

http://www.heuveltop.nl/BasCB/msac_index.html

[Margaret and Loren Block]

Re: Can't save decimal numbers

On Fri, 24 Jun 2005 08:38:08 +0100, Bas Cost Budde
<b.costbudde@he uvelqop.nl> wrote:
[color=blue]
>You probably have an integer field.
>You have to both set the type to numerical, and the subtype to either
>Single or Double (precision floating point). Numerical defaults to Long
>(integer)
>[/color]
Thanks for your reply but the settings areas follows:

Data Type: Number

On the General Tab:
Field Size: Decimal
Format: General Number or Fixed or Percent
Precision: 18
Scale: 0
Decimal Places: 2

All numerical entries with decimals are changed to integers.

Make sense?
[color=blue]
>lorendi@intern et.com wrote:[color=green]
>> Ok, I know this sounds bizarre and I regret to say it has me baffled. New
>> decimal fields in tables will accept entry of decimal numbers but
>> immediately change same into integers.
>>
>> Can someone please tell me what incredibly silly thing I'm doing to cause
>> this???
>>
>> Thanks[/color][/color]

[dkintheuk]

Re: Can't save decimal numbers

Like Bas says...

Change the decimal Field Size to Double and all should work loverly.

Rob.

[Rick Brandt]

Re: Can't save decimal numbers

Margaret and Loren Block wrote:[color=blue]
> On Fri, 24 Jun 2005 08:38:08 +0100, Bas Cost Budde
> <b.costbudde@he uvelqop.nl> wrote:
>[color=green]
>> You probably have an integer field.
>> You have to both set the type to numerical, and the subtype to either
>> Single or Double (precision floating point). Numerical defaults to
>> Long (integer)
>>[/color]
> Thanks for your reply but the settings areas follows:
>
> Data Type: Number
>
> On the General Tab:
> Field Size: Decimal
> Format: General Number or Fixed or Percent
> Precision: 18
> Scale: 0
> Decimal Places: 2
>
> All numerical entries with decimals are changed to integers.
>
> Make sense?[/color]

Scale = 0 means no decimal places.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Margaret and Loren Block]

Re: Can't save decimal numbers

On 24 Jun 2005 07:54:22 -0700, "dkintheuk" <rmcgregor@fire net.uk.com>
wrote:
[color=blue]
>Like Bas says...
>
>Change the decimal Field Size to Double and all should work loverly.
>
>Rob.[/color]


The nomenclature sure seems odd but changing the Field Size from Decimal to
Double and Format to General Number did it.

Thanks very much.