The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.
My database is to keep a record of investments. I have a separate table for each Stock I am tracking as I have things like a chart mapping the Week ending price for each stock. The last few columns on the table are purely keeping track of each weeks price for the line chart so I can view the progress of the stock over time. The other rows on the table are taken up with each transaction Buy/Sell for each stock, so they need to be sorted by date, whereas the last few columns relate to the chart. I would prefer not to create yet another table for the chart information. I would welcome any suggestions.