If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
need help with pivotchart on report?
Dear all,
I have been trying, in vain, to find a way to my problem...if anyone can help I'll pay him a massive pint of Guiness: I have a car accidents database with a multicriteria research form. On the form there is a button opening a report with the only the search results. I need to integrate a pivotchart, a simle one, that would only use the forms results and not the entire data base. The chart is on a form named "frmtest" using an SQL statement from a global query + the a field with sum of dead and injured. When I stick the form into the report and link the master and child fields by "AccID" all I see is the first bar...I don't have a clue how to get the chart on the fly from the results of my form. Thanks for all inputs! |
Thread Tools | |
Display Modes | |
|
|