Converting Sined Fields

[Gene]

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

 

[Rick B]

One post per question please...

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

 

[Brendan Reynolds]

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;