L
Lewis Morgan via AccessMonster.com
I have created a report that gets its information from a query. The
criteria the query asks for is the name of the buyer, start date & end
date. This will product the pie chart no problem.
I want to all a field on the chart to also display the name of the buyer.
I have tried the follwing in the control source of the text box with no
success:
[Queries]![Pie buyer & result]![buyer]
I have also tried creating a form so that the entries are placed there and
then telling the query to get the information from the forms as so:
[Forms]![Pie]![Text39]
I have then tried the control source again to the aboev but sill nothing.
Any suggestions as I'm slowly pulling my hair out :-(
Lewis
criteria the query asks for is the name of the buyer, start date & end
date. This will product the pie chart no problem.
I want to all a field on the chart to also display the name of the buyer.
I have tried the follwing in the control source of the text box with no
success:
[Queries]![Pie buyer & result]![buyer]
I have also tried creating a form so that the entries are placed there and
then telling the query to get the information from the forms as so:
[Forms]![Pie]![Text39]
I have then tried the control source again to the aboev but sill nothing.
Any suggestions as I'm slowly pulling my hair out :-(
Lewis