Hi all,
Thanks in advance for any help you can provide.
I'm currently building a database to store a number of characteristics of machines at my work and am having trouble with a report. I am recording the downtime of each machine along with the frequency of stoppages and want to display this data on a report along with a chart of it. I have the machines grouped in four different sections, with 3 reports generated for each section. These reports are the Top 5 weekly issues, Top 5 monthly issues and then Top 5 over a user defined period of time. Everything works fine, except for the final report with parameter inputs. The user is asked for the date, but is prompted twice, once for the data displayed on the report, and once for the chart displayed on the same report.
If two different periods of time are entered for each of the two prompts, the first date range is displayed in the data, and the second data range is displayed on the chart.
This problem is really doing my head in and I can't figure out how to link the chart and the data so the dates only have to be entered in once before displaying the required results on the report.
If anyone could sched some light on this problem, that'd be great.
Thanks,
James