C
Chris S
I am trying to create a chart report in MS Access 2000. The main file the report is based on is a master file, 1 record/row per production line and shift in our plant.
The option is run from a form, where a beginning and ending date is keyed, to be used for a filter on the charts described below, and for headings on the report.
Program flows like this:
Form, enter date range, click run
Executes a Macro,
1) Macro runs a make-table query to select the subset of data and summarize Downtime minutes by Line/Shift/ReasonCode.
2) Macro then runs report, which displays report, 1 page per line/shift, of Reason Codes in descending minutesdown sequence. Charts are based on a query of table created in step 1, sorted as stated.
On each page of this report I have a bar chart that displays information married to the parent report by 2 linking fields. I had to key these fields into the Linking Child/Master Fields, separated by a semicolon, because it continually told me the forms were unbound, tho I have created a relationship between the query and the master file.
The charts all come up blank.
The made table has data. The query the charts are based on ALSO has data.
Wassup?
The option is run from a form, where a beginning and ending date is keyed, to be used for a filter on the charts described below, and for headings on the report.
Program flows like this:
Form, enter date range, click run
Executes a Macro,
1) Macro runs a make-table query to select the subset of data and summarize Downtime minutes by Line/Shift/ReasonCode.
2) Macro then runs report, which displays report, 1 page per line/shift, of Reason Codes in descending minutesdown sequence. Charts are based on a query of table created in step 1, sorted as stated.
On each page of this report I have a bar chart that displays information married to the parent report by 2 linking fields. I had to key these fields into the Linking Child/Master Fields, separated by a semicolon, because it continually told me the forms were unbound, tho I have created a relationship between the query and the master file.
The charts all come up blank.
The made table has data. The query the charts are based on ALSO has data.
Wassup?