Senin, 20 Mei 2013

RE: [MS_AccessPros] Linking Tables Question (Junction Table ?)

 

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)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar