summation in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There are 100 numerical entries for each day of a month. The fields are date,
time, and amount. How can the entries be added for each individual day of the
month in one query run?
 
phil said:
There are 100 numerical entries for each day of a month. The fields are date,
time, and amount. How can the entries be added for each individual day of the
month in one query run?
Click to expand...

Something like this:

PARAMETERS [What month?] Byte;
SELECT date_column, Sum(amount) As Total
FROM <table name>
WHERE Month(date_column) = [What month?]
GROUP BY date_column
 
Back
Top