#Error in report from division

[diddydustin]

I have data that looks like this:

Employee TotalSheets SumOfSum Of Time_Total
Andy Dietrich 130970 36.4
Ben Lane 35900 3.8
Bo Brandenburg 128000 57.5
Darrell McKinney 187910 180.5
David Carter 150500 114.983333333333
Derek Enlow 184200 166.3
Earl McCoy 70700 22
Glenn Suel 65000 14.2
Greg Goins 119000 103
Harvey Farris 11000 8
James Gorman 10000 99.2
Jerry Carter 115900 102.983333333333
Jerry Colyer 12700 2
Jerry Renner 126800 120.3
Mark Loudermilk 64500 47.5
Mike Eldridge 65000 14.2
Monte Stamper 65000 16.2
Robert Adams 19700 8
Robert E. Adams 89040 24.8
Shane Franklin 46000 7.98333333333333
Sonny Preston 85300 16
Steve Burton 97500 57.5


In my report, I have a textbox trying to do this:


=[TotalSheets]/[SumOfSum Of Time_Total]

However, this is resulting in an error. As you can see, there are no NULL values in my query, so I cannot determine the source for the error.

I am also building this query for the TotalSheets and SumOfSum Of Time_Total values:

SELECT EMR_SheetsUnion.Employee, EMR_SheetsUnion.TotalSheets, Sum(EMR_TimeUnion.[Sum Of Time_Total]/3600) AS [SumOfSum Of Time_Total]
FROM EMR_SheetsUnion INNER JOIN EMR_TimeUnion ON EMR_SheetsUnion.Employee = EMR_TimeUnion.Employee
GROUP BY EMR_SheetsUnion.Employee, EMR_SheetsUnion.TotalSheets;


Is it possible to perform this calculation in the query?

Thank you
Dustin

 

[THWatson]

Dustin
Where are you putting your text box that results in the #Error?

Have you tried putting it in the report footer?

Tom

 

[diddydustin]

Just tried that, still getting an error.

I am putting that textbox in the Detail section of the report. It results from the division-- I can just choose a value and it displays it fine in the box. However, when I try to perform this calculation I get an error.

Thanks
Dustin

 

[dhookom]

1) make sure the name of the text box is not also the name of a field
2) if you just bind the one field, does it appear left or right aligned?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[diddydustin]

Duane,

It was the textbox being named the same as the field. Thanks!

Dustin