B
BOONER
I have a query that selects the data shown below. I would like to display
this data as a series of line charts in a report. I would like to have group
footers for both region, and campaign that contain the charts. So what I
need is for the charts to show the number of leads recieved each day by
region by campaign. I will also need a line chart in the campaign footer
that shows the total number of leads recieved each day (across all regions).
I am having some difficulty using the charts in Access. Where is the best
place to learn about charts in Access?
CAMPAIGN Region Date Leads
Oct-06 TSi - South 10/24/2006 108
Oct-06 FMU West 10/24/2006 93
Oct-06 TSi - West 10/24/2006 75
Oct-06 TSi - East 10/6/2006 1
Nov-06 TSi - West 10/24/2006 1
Oct-06 Northwest 10/15/2006 20
Nov-06 Northwest 10/23/2006 50
Oct-06 TSi - East 10/4/2006 25
Nov-06 Southwest 10/24/2006 2
Oct-06 FMU East 10/15/2006 5
Oct-06 Midwest 10/4/2006 52
Oct-06 Northwest 9/26/2006 2
Oct-06 TSi - West 9/26/2006 4
Oct-06 Northwest 10/5/2006 2
Oct-06 Southwest 10/3/2006 2
Oct-06 Southwest 10/10/2006 1
this data as a series of line charts in a report. I would like to have group
footers for both region, and campaign that contain the charts. So what I
need is for the charts to show the number of leads recieved each day by
region by campaign. I will also need a line chart in the campaign footer
that shows the total number of leads recieved each day (across all regions).
I am having some difficulty using the charts in Access. Where is the best
place to learn about charts in Access?
CAMPAIGN Region Date Leads
Oct-06 TSi - South 10/24/2006 108
Oct-06 FMU West 10/24/2006 93
Oct-06 TSi - West 10/24/2006 75
Oct-06 TSi - East 10/6/2006 1
Nov-06 TSi - West 10/24/2006 1
Oct-06 Northwest 10/15/2006 20
Nov-06 Northwest 10/23/2006 50
Oct-06 TSi - East 10/4/2006 25
Nov-06 Southwest 10/24/2006 2
Oct-06 FMU East 10/15/2006 5
Oct-06 Midwest 10/4/2006 52
Oct-06 Northwest 9/26/2006 2
Oct-06 TSi - West 9/26/2006 4
Oct-06 Northwest 10/5/2006 2
Oct-06 Southwest 10/3/2006 2
Oct-06 Southwest 10/10/2006 1