Blank Chart 1

[corycrum]

Hi,

I would like to create a simple report with a bar chart to show sales by team, by employee. The report is based on a simple table (T_Sales_By_Team). T_Sales_By_Team has the following fields:

TeamName
EmployeeName
Sales

I have created a report that groups on the TeamName field. I have inserted a bar chart in the TeamName footer. If I set the Link Master/Child fields to TeamName, the chart is blank when in preview mode. If remove the Link Master/Child fields the chart populates with data, but it shows data for all employees for all teams on every chart. I want the chart to update with new employee names as I cycle from one TeamName to the next. I don't want to display all employees on all charts. What am I missing?

 

[dhookom]

Do you have a text box in the TeamName footer bound to TeamName?

Duane
Hook'D on Access
MS Access MVP

 

[corycrum]

Brilliant! That worked. Thanks!