Date Range

  • Thread starter Thread starter rogerscmg
  • Start date Start date
R

rogerscmg

Hey Guys,

I have a query right now that allows me to pull the number of email
campaigns i sent in January, and then totals the number of people each
email was sent. So say for Jan, Chatelaine magazine had 4 eMail
efforts, and each email was sent to AT LEAST 65,000 people, so the
total for all 4 would be 260,000 emails sent.

Problem is, i need to do this for each month of year, for TWELVE
different magazines. that's tooooo many query runs for my liking.

is there a way to have ALL months pulled and thier respective totals
for each month?

Thanks
 
Hey Guys,

I have a query right now that allows me to pull the number of email
campaigns i sent in January, and then totals the number of people each
email was sent. So say for Jan, Chatelaine magazine had 4 eMail
efforts, and each email was sent to AT LEAST 65,000 people, so the
total for all 4 would be 260,000 emails sent.

Problem is, i need to do this for each month of year, for TWELVE
different magazines. that's tooooo many query runs for my liking.

is there a way to have ALL months pulled and thier respective totals
for each month?

Thanks
Click to expand...

Sure. Use a Totals query or a Crosstab query, probably using a calculated
field such as:

YearMonth: Format([datefield], "yyyymm")

Post some details of your table structure if you need help setting this up.
 
Back
Top