Below is my code that gives me an average number of gauges
calibrated by day by date range. If the answer is 0 for
the date range selected how can I get 0 to show in the
query?




SELECT GagesTotalByDateRange.Gages/UniqueDatetotals.[CountofDate Due] AS [Total Gages Avg]
FROM GagesTotalByDateRange, UniqueDateTotals;

Below is my code that gives me an average number of gauges
calibrated by day by date range. If the answer is 0 for
the date range selected how can I get 0 to show in the
query?



SELECT GagesTotalByDateRange.Gages/UniqueDatetotals.[CountofDate Due] AS [Total Gages Avg]
FROM GagesTotalByDateRange, UniqueDateTotals;


I assume you want to avoid the error caused by division by zero. Try the following Statement instead


Select IIf((UniqueDatetotals.[CountofDate Due]=0), 0,
GagesTotalByDateRange.Gages/UniqueDatetotals.[CountofDate Due])
AS [Total Gages Avg]
FROM GagesTotalByDateRange, UniqueDateTotals;

Thanks for the help. That worked great!