Well this should be interesting, new look? I finally got everything running great and along came my boss to screw everything up. He wants to see graphs on a couple of the reports. So I started with the Open_MRA_Report, which is run from a query, and it works good. The probelem is the original creator used chkboxes, so now I have four chkboxes which can output seven different combinations which I want to graph.
Chkboxes:
MRA
QA
IC
CC
Output Compinations to Graph:
MRA
MRA & QA
MRA & QA & CC
CC
CC & QA
CC & MRA
IC & QA
Had I known this was coming at me I would have done things different, but I thought I could keep the look the same, bad choose I know. I started a new report an use the chart tool to create a query from the query that did the reports but the combination of chkboxes in SQL was not very good it produced a blank report. Does anyone have a few suggestions on what I can do with those chkbox combinations to get them working? Is this even possible? Or should I be going back to scratch and starting over? Thank you in advance to anyone who even has a suggestion here. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/confused.gif)
PS: This is my first graph so keep it simple at the beginning.