group records by month

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

Guest

hi, in my main table, [Journal], each record has a date (mm/dd/yy). In my
query I want to pull all the records of a single month and group those
records together. Meaning, when i query for rent, i want it to total all
january together and show 650 or whatever, rather than several records in
january totaling 650. thanks for any help
 
Use a totals query and use a calculated value based on the datefield to group by
or select your records.

A simple sample SQL statement might look like:


SELECT Sum(Rent) as TotalRent
FROM Journal
WHERE Format(DateField,"YYYYMM") = "200409"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query records by month 2
Sort by Month 1
Date format 1
A Complicated Query Question 4
Record Count 2
Previous Month in query 1
Cross-tab Criteria not evaluating 19
Group by month then count rows 4

Back
Top