accessNator
Registered User.
- Local time
- Today, 05:20
- Joined
- Oct 17, 2008
- Messages
- 132
I have a table in SQL Server that a column uses a FLOAT Data type. If I create a table link in access from that particular table, the column where the data type is a float some values looks odd.
e.g. In my SQL table where a rate is defined it looks like this:
0.00300000002607703
But when I view it in Access it looks like this:
3.00000002607703E-03
Access defines the column as a data type of NUMBER, FIELD SIZE as DOUBLE.
Do I assume these values are equally the same?
e.g. In my SQL table where a rate is defined it looks like this:
0.00300000002607703
But when I view it in Access it looks like this:
3.00000002607703E-03
Access defines the column as a data type of NUMBER, FIELD SIZE as DOUBLE.
Do I assume these values are equally the same?
