Adding a Decimal Point

[b1rans]

I have an Access 2010 table which shows Latitude and Longitude. However instead of it being in a decimal format it is displayed as 4000000000. I need to add a decimal point so that it looks like 40.00000000. If I configure the Field Properties to Decimal with a scale of eight and decimal places set to eight I can manually convert all of the data to the correct format. But I would like to have this happen automatically from a query. Any Ideas?

 

[spikepl]

What is the data type and what is the actual value contained in that field? Because 4,000,000,000 is beyond the range of even Long ...

 

[b1rans]

The Data type is number and the field type is Decimal. An example of the actual value is 4059739039but I would like it to be 40.59739039.

 

[spikepl]

In the query, show the value multiplied by 0.00000001

Edit:

Actually, a division by 10000000 which is a Long might be better, so you don't loose any precision.

You may also have to look into Cdec function, because it is not obvious to me what type the result of the operation would become.

 

[b1rans]

That Worked! Thank you very much!