Formatting a double number in a query 1

[robojeff]

I have a query that is pulling a number from a "read only" table which is set up in the table as a double data type.

In one instance, the number is 0.590 but is stored in the table as 590, so I set my query to calculate numbers in this field to be:

Qty: ([QTY]/1000)

and in this case, my query reports this value as 0

How can I "type cast" my query to pull in the actual value
of 0.590 (with 3 places to the right of the decimal point)?

Thanks

 

[smedvid]

Simple Format statement will force (3) digits. htwh...

SELECT Table1.F1 AS Orig_Val, Format([F1]/1000,"0.000") AS New_Val
FROM Table1;

Steve Medvid
IT Consultant & Web Master

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...