P
phil access
Intend to sum a series of values for each day of a particular month.
This is the query that didn’t work. The result just gave a list of the data.
SELECT [AWY003~1].Date, [AWY003~1].Time, Sum([AWY003~1].head) AS SumOfhead
FROM [AWY003~1]
GROUP BY [AWY003~1].Date, [AWY003~1].Time;
Based on a user response, the following query was able to provide a
summation of values for each day of a particular month.
PARAMETERS [What month?] Byte;
SELECT date AS Expr1, Sum([AWY003~1].head) AS Total
FROM [AWY003~1]
WHERE (((Month([date]))=[What month?]))
GROUP BY date;
How can this query be expanded to sum values for each day of the year?
This is the query that didn’t work. The result just gave a list of the data.
SELECT [AWY003~1].Date, [AWY003~1].Time, Sum([AWY003~1].head) AS SumOfhead
FROM [AWY003~1]
GROUP BY [AWY003~1].Date, [AWY003~1].Time;
Based on a user response, the following query was able to provide a
summation of values for each day of a particular month.
PARAMETERS [What month?] Byte;
SELECT date AS Expr1, Sum([AWY003~1].head) AS Total
FROM [AWY003~1]
WHERE (((Month([date]))=[What month?]))
GROUP BY date;
How can this query be expanded to sum values for each day of the year?