04-30-14, 07:06 #1Registered User
- Join Date
- Nov 2012
Unanswered: One chart, multiple data...line..things, one rowsource
Graphs and charts are unknown territory to me in general considering I haven't messed with them since math class in high school. I'm having some issues incorporating one into my application.
I have a table, it's called Flightlog, and it hold ALL of the information that I need.
I have a query, called FlightLog_Charts, I've asked it to give me a date range between two controls on a related form, the number of flights that occurred during that timeframe that were "Completed", the number of flights that were declined for various reasons.
I have a report named FlightLog_Graphical and I want one line graph on it.
In that line graph I want it to give me a graphical representation of the number of completed flights in said date range in one color.
I want it to show me another graphical representation of declined flights on the same graph, in a different color.
I'm not sure if I'm not getting the query right, or I'm going about obtaining the data the wrong way, but both of the lines follow exactly the same pattern which shouldn't be the case. I suspect it's just counting the number of records in the query for both cases. I'm not sure if I need two different queries here and if so, I have not the slightest on how to do that.
As always your expertise is appreciatedVersion: Access 2010
05-01-14, 10:48 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
Linq ;0)>Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007