Connecting a Risk Cube or Graph from Excel into Access and use a query to populate the graph

[June7]

I had one situation where I used the overlaying multiple graphs technique until I figured out how to have all the data in one.



Graph control has Master/Child Links properties that should be able to synchronize the graph data with current record on form/report. However, I've never had any luck with that approach. So I have graph RowSource reference a field/textbox on form/report as filter criteria. Examples:

SELECT M, D, FD, ZD, ZDM FROM GraphProctor WHERE LabNum=[tbxLabNum];

SELECT [DropNum], [CumulativePenMM] FROM [dcpfiledata] WHERE [HoleNum] = [Hole];

[kingofthekassel]

I really appreciate the help you are providing. I am trying to look up what these terms mean, can you tell me what they refer to?

"DropNum"
"CumulativePenMM"
"dcpfiledata"
"HoleNum"
"Hole"

I am still fairly new to access. sorry

[June7]

Those are field and table names from my database. The SQL statements are intended as examples, not for your use as is.

[kingofthekassel]

So if I wanted to sort for riskNo mine would look something like:

SELECT Final_Risks_Query.RiskNo, Final_Risks_Query.First_Porbability, Final_Risks_Query.FirstConsequence
FROM "Final Risks Query";


Assuming Final Risks Query is the name of the query from which I want to pull the information, is this correct?

[June7]

Use [] instead of quote marks.

Not using a WHERE clause to filter records.


Advise no spaces in naming convention.

[kingofthekassel]

okay I changed to the brackets, but now it takes me to this screen... How is this going to get me only one graph at a time?

[June7]

Do you have a saved query object named Final_Risk_Query? Did you build a graph on form? Are you putting this SQL statement into the RowSource property of graph?

[kingofthekassel]

I think yes to all of those questions. this picture should show all of that.

[June7]

I analyze graph issues best when I can work with data. If you want to provide db, follow instructions at bottom of my post.

Note Probability is misspelled as Porbability. Might want to modify field name in table and/or query.

The actual query name does not have underscores - it has spaces - already advised not to do that.

[kingofthekassel]

Thank you so much! It works