Format Double Question

[q582gmzhi]

Hi,

I have been asked to run a query on an existing db and output certain fields as type Double.

The fields in question are currently type Currency.

How do I change the format from Currency to Double or do I need to?

Thanks in advance

Daz....

 

[Jon K]

You can use the CDbl() function on the field to convert it to Double.
.

 

[q582gmzhi]

Thanks for your help.

Daz...

 

[namliam]

Actually the biggest difference between Currency and Double is the format which is automaticaly applied....

 

[Jon K]

Actually the biggest difference between Currency and Double is the format which is automaticaly applied....

Their difference is more than just in the display. They have different ranges and serve different purposes.

The following is taken from Access' help files.
Double
Stores numbers from -1.79769313486231E308 to -4.94065645841247E-324 for negative values and from 1.79769313486231E308 to 4.94065645841247E-324 for positive values. Decimal precision 15

A Currency field is accurate to 15 digits to the left of the decimal point and 4 digits to the right.


Tip You can use the Currency data type if you plan to perform many calculations on a field that contains data with one to four decimal places. Single and Double data type fields require floating-point calculation. Currency data type fields use a faster fixed-point calculation.
.