I have a table in a sql server which is accessed by a Microsoft Access FE.
The mentioned table has a field named "Multiplier" with a "real" data type. It's used for some engineering calculations.
Because of a change in our company's policy and the problems with real data type, I'm considering changing the "real" data type to "money".
Will this convert effect on the first 4 decimal digit of my current data?
For now, I'm running the following query to see what will happen after the convert.
The result after running the above query shows zero records.
But since the data is very crucial in my job, I thought I may ask for advices here before doing something that may cause me troubles in future.
I really don't want to run into a situation when several years down the road, when someone searches for an old record, the data on screen is different with the printed reports.
Thanks for any kind of advice.
The mentioned table has a field named "Multiplier" with a "real" data type. It's used for some engineering calculations.
Because of a change in our company's policy and the problems with real data type, I'm considering changing the "real" data type to "money".
Will this convert effect on the first 4 decimal digit of my current data?
For now, I'm running the following query to see what will happen after the convert.
SQL:
SELECT
Multiplier AS OriginalValue,
CAST(Multiplier AS MONEY) AS AsMoney,
Multiplier - CAST(Multiplier AS MONEY) AS Difference
FROM
dbo.SingleEst
WHERE
Multiplier IS NOT NULL
AND ROUND(Multiplier, 4) = ROUND(CAST(Multiplier AS MONEY), 4)
AND ROUND(Multiplier, 5) <> ROUND(CAST(Multiplier AS MONEY), 5);
The result after running the above query shows zero records.
But since the data is very crucial in my job, I thought I may ask for advices here before doing something that may cause me troubles in future.
I really don't want to run into a situation when several years down the road, when someone searches for an old record, the data on screen is different with the printed reports.
Thanks for any kind of advice.