A
Andi B
Greetings all,
I have a form in a database with data on, and this data is used to create a
chart that appears in a second form when the user presses a button. As the
data on the form changes from record to record, the chart on the second form
is created using an SQL statement that lifts necessary information from the
table behind the form where the item identification numbers match.
The chart was created to be a bar and line graph, the bar showing projected
stock levels over the course of a year (split into quarters, Qtr 1, Qtr2
etc) and the line is mean to be a re-order level figure. This figure remains
constant across all four periods - the idea being that when you are in the
quarter where the stock figure dips below the re-order level a buy for
replacement items is started.
The problem I have is this: When the form with the chart on appears, both
the bar and line plot the same data. Is there a way to make the chart plot
the information separately as I described above?
I would be more than willing to explain this in more detail if thats whats
required.
Many thanks in advance of any assistance,
Regards,
Andi
I have a form in a database with data on, and this data is used to create a
chart that appears in a second form when the user presses a button. As the
data on the form changes from record to record, the chart on the second form
is created using an SQL statement that lifts necessary information from the
table behind the form where the item identification numbers match.
The chart was created to be a bar and line graph, the bar showing projected
stock levels over the course of a year (split into quarters, Qtr 1, Qtr2
etc) and the line is mean to be a re-order level figure. This figure remains
constant across all four periods - the idea being that when you are in the
quarter where the stock figure dips below the re-order level a buy for
replacement items is started.
The problem I have is this: When the form with the chart on appears, both
the bar and line plot the same data. Is there a way to make the chart plot
the information separately as I described above?
I would be more than willing to explain this in more detail if thats whats
required.
Many thanks in advance of any assistance,
Regards,
Andi