Hi, would you please help me how to set up this query:
I have several tables that list quarterly information on companies. (Col A is Company Name, Col. B is quarterly date, Co. C is Sales of the quarter, and D is Net Income of the Quarter.
I would have these table for each quarter: FQ032013, FQ122012, FQ092012, FQ062012, and FQ032012.
So at the end of each quarter, I would have a new table. By the end of June, I will have a new table named FQ062013.
For now, my most recent data available is from table FQ032013, but by July, my most recent data will be from the new table FQ062013 and 1 older quarter will be from FQ032013 and 2 older quarter will be from FQ122012.
Would you please show me how to create a junction table (?) so that I can up date the Most Recent Quarter (0) to be the FQ032013 for now, but in a couple of month I will change it to FQ062013.
The goal is for me to be able to write a query to to get the most recent data from the table indicated as most recent table in the junction table.
Thanks in advance for your instruction!
Tim
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar