Hi
If I have a table with the following information
Invoice Date
| Invoice No
|
Stock Code | Sell Price | Cost Price |
|---|
| 01/01/2012 | INV01 | STK1 | 100 | 35 |
| 01/02/2012 | INV02 | STK1 | 100 | 35 |
| 01/03/2012 | INV03 | STK1 | 100 | 35 |
| 01/04/2012 | INV04 | STK1 | 100 | 35 |
| 01/05/2012 | INV05 | STK1 | 100 | 35 |
And I have another table with the following info
| Date | Stock Code
| Hidden Cost
|
|---|
| 01/01/2012 | STK1 | 45 |
| 14/03/2012 | STK1 | 50 |
If I wanted to create a chart with the following columns
Invoice Date, Invoice Number, Stock Code, Margin, Hidden Margin
The margin is the difference between Sell and Cost Prices
The hidden margin is the difference between the Sell and Hidden Costs.
I am guessing I would I need to generate a record in the second table for everyday of the year, and then I can link the invoice date and stock item to this data.
Can someone please explain how to do this, or point me at a resource that explains how to generate the data.
Thanks
Andy
