Reports based on a query....

  • Thread starter Thread starter Lewis Morgan via AccessMonster.com
  • Start date Start date
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
 
Add the name of the buyer as part of the query for the pie chart,

the sql stament of the chart will look like this

select buyer_name, dated, sum(Amount) from MyPurchasestable where
buyer_name=forms!Myparameter_frm!Buyer_name
 
Back
Top