I'm sure its already been posted but I wasn't able to find anything on this.
I have a table that has a field "Unit Price" which is a sined field. I need
to convert the field to regular number or even better an implied decimal(eg.,
10058=100.58) But dont worry too much about that. Just need a query or a way
to convert the sined field into a large interger. Thanks advance.
Gene

One post per question please...

Netiquette FAQ
http://www.mvps.org/access/netiquette.htm


--
Rick B



"Gene" <(E-Mail Removed)> wrote in message
news:998970CA-D6F6-4EC5-9285-(E-Mail Removed)...
> I'm sure its already been posted but I wasn't able to find anything on
> this.
> I have a table that has a field "Unit Price" which is a sined field. I
> need
> to convert the field to regular number or even better an implied
> decimal(eg.,
> 10058=100.58) But dont worry too much about that. Just need a query or a
> way
> to convert the sined field into a large interger. Thanks advance.
> Gene
>

If I understand the question correctly, don't you just need to divide by
100? For example, in a query ...

SELECT [TestField]/100 AS ConvertedValue
FROM tblTest;

--
Brendan Reynolds
Access MVP

"Gene" <(E-Mail Removed)> wrote in message
news:998970CA-D6F6-4EC5-9285-(E-Mail Removed)...
> I'm sure its already been posted but I wasn't able to find anything on
> this.
> I have a table that has a field "Unit Price" which is a sined field. I
> need
> to convert the field to regular number or even better an implied
> decimal(eg.,
> 10058=100.58) But dont worry too much about that. Just need a query or a
> way
> to convert the sined field into a large interger. Thanks advance.
> Gene
>