G
Guest
I have a query that uses the datediff function to determine the "turnaround
time" or number of days to complete a task. I have this field format set as
FIXED in the query. Then there is another query that calculates the average
of "turnaround time". I have set this field's format property to FIXED also.
The first query runs properly and gives me a number with two decimal places.
The problem is that when I run the second query, the average value has too
many decimal places. Changing the format to STANDARD or even CURRENCY has no
effect on the number of decimal places for the average.
There is a report based on the second query. I have tried setting the format
of the control based on Turnaround Time to fixed with 2 decimal places. I
also tried entering a custom format of #.## or 0.00, with no effect on the
number of decimal places.
The only way I could control the number of decimal places in the Average
Turnaround Time was to use the ROUND function. Does anyone know why setting
the format property didn't work for me?
Access 2003/Win2000
Thanks,
Mary
time" or number of days to complete a task. I have this field format set as
FIXED in the query. Then there is another query that calculates the average
of "turnaround time". I have set this field's format property to FIXED also.
The first query runs properly and gives me a number with two decimal places.
The problem is that when I run the second query, the average value has too
many decimal places. Changing the format to STANDARD or even CURRENCY has no
effect on the number of decimal places for the average.
There is a report based on the second query. I have tried setting the format
of the control based on Turnaround Time to fixed with 2 decimal places. I
also tried entering a custom format of #.## or 0.00, with no effect on the
number of decimal places.
The only way I could control the number of decimal places in the Average
Turnaround Time was to use the ROUND function. Does anyone know why setting
the format property didn't work for me?
Access 2003/Win2000
Thanks,
Mary