Reply
Mon 29 Nov, 2004 08:35 am
Hello
I have a small access database which generates a number of reports. One of the reports details the average percentage of calls a user answers correctly. (data obtained from a query)
SQL = SELECT QA.[Ticket Owner], Avg(QA.User_Total) AS AvgOfUser_Total, Avg(QA.Type_Total) AS AvgOfType_Total, Avg(QA.Small_Total) AS AvgOfSmall_Total, Avg(QA.Full_Total) AS AvgOfFull_Total, Avg(QA.Find_Total) AS AvgOfFind_Total, Avg(QA.Grand_total) AS AvgOfGrand_total, Count(QA.QAID) AS CountOfQAID
FROM QA
GROUP BY QA.[Ticket Owner]
HAVING (((QA.[Ticket Owner])=[Name of the SDA eg John, Karen, Cindy, Steve, Rich or Jess]));
I am trying to format the value displayed in the report so that it has 0 decimal places. but cannot get this to work.
I have tried specifying in the table QA that there is 0 decimal places, I've tried to specify 0 decimal places in the actual query but still get decimal places.
Is there anything I can do?
Cheers
Kedge
if it's small you could email it to me
460Kb, is that OK to email?
Or I can upload it to my website and you can download it if you want.
Have you tried formatting the text box control on the report? Set the format (through Properties) of the control(s) to "Standard" and specify 0 decimal places. That way, you get the display in whole numbers, but the underlying calculations are done with more accuracy.