Pivot Chart with several series fields

K

karaeloko

I have a form with a combo box to choose a flight number and then a command
button to requery the subform that is based on a PivotChart query.

How can I add several combo boxes so I can a plot a graph with several series.

This is the SQL code for my query:

SELECT tblRdayLeg.Ddate, tblRdayLeg.FltNum, tblRdayLeg.RSH
FROM tblRdayLeg
GROUP BY tblRdayLeg.Ddate, tblRdayLeg.FltNum, tblRdayLeg.RSH
HAVING (([tblRdayLeg]![FltNum] =
[Forms]![frmBookingsCurves]![cboFlightGraph]));

What I need is to have, let´s say, 2 combo boxes so I could choose 2
different flight numbers, so I would get a chart with 2 lines.

Thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Creating a Search using a combo box and then creating a report. 4
Template with fields and premade texts.. 0
Link a text box based on drop down box with four options MS Word 365 0
How to set a rotating shift schedule for 4 crews with repeat occurrence? -SOLVED 1
Grow/Shrink Text gradually from slide to slide 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Dealing with a Pivot Table (when I don't want to) 0

Top