ROUND still doesn't work.

A

Allen_N

My previous post did not generate a solution, so here I go again. The
following SQL produces a column with 12 decimal places:

SELECT ROUND([UFS 1] / AVERAGE_COST, 1) AS [UF 1]
FROM dbo.View_Underforecast_111

Why isn't it rounding?

I tried putting a form on top of it and setting the format to show 1 decimal
place, but the result is the same!

(This project is an Access 2000-format ADP under Office 2003.)

Thanks!
 
A

Andy Hull

Hi

Can you give us examples of the typical values involved in the division?

And, (one of) the exact result(s) being displayed?
 
A

Allen_N

Thanks, Andy.

The input view-query [View_Underforecast_111] is an inner join between 2
tables. It also uses ROUND(x, 1) but its output is as expected:

1st rec: [UFS 1] = 0, [AVERAGE_COST] = 14.23
8th rec: [UFS 1] = 220.7, [AVERAGE_COST] = 110.37

When the view-query [View_Underforecast_111a] applies "ROUND([UFS 1] /
AVERAGE_COST, 1)" the corresponding output is:

1st rec: [UF 1] = .00000000000000000
8th rec: [UF 1] = 2.00000000000000000

So, I guess the rounding function is working, but the output format has too
high a precision.


Andy Hull said:
Hi

Can you give us examples of the typical values involved in the division?

And, (one of) the exact result(s) being displayed?



Allen_N said:
My previous post did not generate a solution, so here I go again. The
following SQL produces a column with 12 decimal places:

SELECT ROUND([UFS 1] / AVERAGE_COST, 1) AS [UF 1]
FROM dbo.View_Underforecast_111

Why isn't it rounding?

I tried putting a form on top of it and setting the format to show 1 decimal
place, but the result is the same!

(This project is an Access 2000-format ADP under Office 2003.)

Thanks!
Click to expand...
Click to expand...
 
A

Andy Hull

Hi Allen

I haven't been able to duplicate this problem with round so I am only
guessing at possible work arounds without full understanding but have you
tried using "format"

eg

SELECT FORMAT([UFS 1] / AVERAGE_COST, "0.0") AS [UF 1]
FROM dbo.View_Underforecast_111

hth

Andy


Allen_N said:
Thanks, Andy.

The input view-query [View_Underforecast_111] is an inner join between 2
tables. It also uses ROUND(x, 1) but its output is as expected:

1st rec: [UFS 1] = 0, [AVERAGE_COST] = 14.23
8th rec: [UFS 1] = 220.7, [AVERAGE_COST] = 110.37

When the view-query [View_Underforecast_111a] applies "ROUND([UFS 1] /
AVERAGE_COST, 1)" the corresponding output is:

1st rec: [UF 1] = .00000000000000000
8th rec: [UF 1] = 2.00000000000000000

So, I guess the rounding function is working, but the output format has too
high a precision.


Andy Hull said:
Hi

Can you give us examples of the typical values involved in the division?

And, (one of) the exact result(s) being displayed?



Allen_N said:
My previous post did not generate a solution, so here I go again. The
following SQL produces a column with 12 decimal places:

SELECT ROUND([UFS 1] / AVERAGE_COST, 1) AS [UF 1]
FROM dbo.View_Underforecast_111

Why isn't it rounding?

I tried putting a form on top of it and setting the format to show 1 decimal
place, but the result is the same!

(This project is an Access 2000-format ADP under Office 2003.)

Thanks!
Click to expand...
Click to expand...
Click to expand...
 
Top