Return Query Values by Month

[Guest]

I have a datesent field with a range of dates. I want to be able to
calculate result totals by month without seeing all the detail. Can Access
decipher all dates within January to equal January and give a one line total?

 

[Van T. Dinh]

You can create a Calculated Field:

MYSent: Format([DateSent], "mmmm/yyyy")

in your Total Query and Group By this calculated Field.

 

[fredg]

I have a datesent field with a range of dates. I want to be able to
calculate result totals by month without seeing all the detail. Can Access
decipher all dates within January to equal January and give a one line total?

SELECT Format([DateField],"mm/yyyy") AS TheMonth,
Sum(YourTable.ANumber) AS Amount
FROM YourTable
WHERE (((Year([DateField]))=2005))
GROUP BY Format([DateField],"mm/yyyy");

If you would like to be prompted for the year change the above
criteria to:
WHERE (((Year([DateField]))=[What Year?]))