Date Range

[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

 

[Douglas J. Steele]

How's the data stored?

 

[rogerscmg]

How's the data stored?

Hey Doug,

Its all in 1 table. Im not sure if that is what your looking for
though?

 

[Douglas J. Steele]

No, I meant what are the fields in the table.

 

[John W. Vinson]

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

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.