Converting Sined Field

[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

 

[Van T. Dinh]

I am not sure from your description but an example of conversion in SQL is:

SELECT [Unit Price] * 100 AS UnitPriceInCents
FROM [YourTable]

BTW, I think you meant *signed* numbers...

 

[Gene]

Nope, I meant Sined as in } or {.

I am not sure from your description but an example of conversion in SQL is:

SELECT [Unit Price] * 100 AS UnitPriceInCents
FROM [YourTable]

BTW, I think you meant *signed* numbers...

--
HTH
Van T. Dinh
MVP (Access)

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

 

[John Vinson]

Nope, I meant Sined as in } or {.

A "Sine" is a trigonometric function.

I have never heard (in Access, in Basic or Visual Basic, in PL/I, or
in my limited experience with C) of a "sined number".

Curly brackets are not used in Visual Basic for Applications.

What's the context? What is a "sined number", and how does it differ
from other types of number? What is the source of this data? Could you
post some examples of the "sined numbers" and the desired result?

John W. Vinson[MVP]