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?
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?
Code:
SELECT GagesTotalByDateRange.Gages/UniqueDatetotals.[CountofDate Due] AS [Total Gages Avg]
FROM GagesTotalByDateRange, UniqueDateTotals;