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 (2) |
Tidak ada komentar:
Posting Komentar