Thank you for your reply, Glen!
However, the actual tables for each of my quarter contain about 100 fields. The example I used in my question is to simplify the question so that I can concentrate on the key issue.
Since I have to use most of the data from several tables, I can't put them all together because of the 255 column limitation. In addition, I would like to keep the historical data, as each quarter I will have new data. Therefore I thought about a "master" table that could control the dates might be the way to go (the most recent quarter (value 0) and 1 quarter older (value 1), and so on.)
Thanks again, Glen!
Tim
--- In MS_Access_Professionals@yahoogroups.com, "Glenn Lloyd" <argeedblu@...> wrote:
>
> Tim,
>
>
>
> It would be far more efficient and far less time consuming to have one table
> with an additional field to indicate the quarter rather than creating a new
> table for each quarter.
>
>
>
> You could then use a parameter query to select the quarter of interest.
>
>
>
> Glenn
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of timdbui
> Sent: Monday, May 20, 2013 8:57 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Linking Tables Question (Junction Table ?)
>
>
>
>
>
> 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
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar