Data Loss Due to Data Field Type?

[santofish]

Hello,

I have received a database that was built by a person that does not work at out company anymore and I'm currently building queries to summarize the data.

Problem:
In one of the tables there is a latitude and longitude field, the data type for both fields was set to "number" and the decimal places was set to "auto".
An example of the data entered is:
Latitude= 46.254568
Longitude= -116.871265

But when I look at the data in the tables it's stored as just either 46 or -116?

Is there any way to recover the data that was entered or is it lost forever since the field was set up incorrectly?
I tried changing the data type and the decimal places to 6 but still the same result. Any help would be appreciated thanks! I'm using Access 2013.
Ryan

[pbaldy]

What is the Field Size? If it's Integer or Long Integer, the decimals were never stored.

[orange]

Did this application ever work --that is show more decimal places?

When you look at the table in design view the field type is Number, but what is the in "Field size"?
I have a table with coordinates --- type is number, field size is Double and decimals Auto.

It stores many decimal places as per sample below.

AnimalId	GPSLong	GPSLat
1	77.9	47.3
1	77.34	46.8
1	78.44	45.32
2	76.33	48.9
2	77.45	48.8
2	78.53	47.54
3	76.2	49.4
4	78.23	47.52
4	78.666	47.66
5	77.7	49.3
5	77.334456	48.9

OOOops: I see Paul has already answered.

[santofish]

Thanks for both of the replies, sorry for the long delay but been battling the flu. Yes the field size is Long Interger, so I guess the data can not be recovered. Just another lesson in making good decision when creating tables!

Ryan

[pbaldy]

Sorry about that.