P
phil access
This query sums a calculated daily value for mgd for January and sorts to
show a maximum daily value. Fields are date, time, gpm, mgd.
There are hundreds of values for each day of the month.
PARAMETERS [What month?] Byte;
SELECT [AWY003~1].Date AS Expr1, Sum([gpm]*10/1000000) AS mgd
FROM [AWY003~1]
WHERE (((Month([date]))=[What month?]))
GROUP BY [AWY003~1].Date
ORDER BY Sum([AWY003~1].gpm) DESC;
How can the same query also find the average of the 31 daily values of mgd?
How can this query then be expanded to include all twelve months?
show a maximum daily value. Fields are date, time, gpm, mgd.
There are hundreds of values for each day of the month.
PARAMETERS [What month?] Byte;
SELECT [AWY003~1].Date AS Expr1, Sum([gpm]*10/1000000) AS mgd
FROM [AWY003~1]
WHERE (((Month([date]))=[What month?]))
GROUP BY [AWY003~1].Date
ORDER BY Sum([AWY003~1].gpm) DESC;
How can the same query also find the average of the 31 daily values of mgd?
How can this query then be expanded to include all twelve months?