Good Morning!
I’ve been browsing the forum and although its helped me alot I can’t seem to get the following right and wondered if anyone could help?
I have two table tblHeader and tblData, the tblHeader contains the following field, Part number, Description, Price, Supplier Code, Supplier Name and tblData contains these fields, Part number, Date, Quantity.
These are linked with a “One-to-Many” relationship. Basically tblHeader contains info regarding a part and supplier and the tblData container the sales info.
This is what I would like to do:
1) Insert a part number, start date and end date into the following text boxes: txtPartNo, txtSDate, txtEDate.
The line graph will then show the sales data for the specified part number within the date range, called 2011 data in the legend. (The date range will atomically be converted to week numbers using DatePart()).
2) The line graph will also show another line called “2010 data” in the legend, for the same part number, but with the above dates - 12months.
I will then be able to have a visual comparison of how the sales are compared to last year, and to see if any increases / decreases are expected based on the previous year.
I can do the automation of the graph etc so don’t need any advise on this, it’s mainly just being able to get the data into the graph (Queries / SQL) which I need help on.
Thanks in Advance!
Chris
I’ve been browsing the forum and although its helped me alot I can’t seem to get the following right and wondered if anyone could help?
I have two table tblHeader and tblData, the tblHeader contains the following field, Part number, Description, Price, Supplier Code, Supplier Name and tblData contains these fields, Part number, Date, Quantity.
These are linked with a “One-to-Many” relationship. Basically tblHeader contains info regarding a part and supplier and the tblData container the sales info.
This is what I would like to do:
1) Insert a part number, start date and end date into the following text boxes: txtPartNo, txtSDate, txtEDate.
The line graph will then show the sales data for the specified part number within the date range, called 2011 data in the legend. (The date range will atomically be converted to week numbers using DatePart()).
2) The line graph will also show another line called “2010 data” in the legend, for the same part number, but with the above dates - 12months.
I will then be able to have a visual comparison of how the sales are compared to last year, and to see if any increases / decreases are expected based on the previous year.
I can do the automation of the graph etc so don’t need any advise on this, it’s mainly just being able to get the data into the graph (Queries / SQL) which I need help on.
Thanks in Advance!
Chris
