Senin, 20 Mei 2013

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

 

Oops! Of course. I will be AFK for a few minutes while I was the egg off my
face.

Thanks John.

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Monday, May 20, 2013 10:35 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Linking Tables Question (Junction Table ?)

Glenn-

Year.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Glenn
Lloyd
Sent: Monday, May 20, 2013 7:00 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Linking Tables Question (Junction Table ?)

Thanks John

I am not clear on what the second field would be. I assume the first is the
Quarter field.

Glenn

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of John
Viescas
Sent: Monday, May 20, 2013 9:56 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Linking Tables Question (Junction Table ?)

Glenn-

Small correction: Adding the quarter info will add, at most, two fields, but
that shouldn't exceed the 255 limit. And I agree about design issues.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Glenn
Lloyd
Sent: Monday, May 20, 2013 6:27 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Linking Tables Question (Junction Table ?)

Tim,

It seems then that your application is suffering from major structural
issues. Are you aware of the rules of normalization? Chances are that with
more than 100 fields in a table, that table is not properly normalized.

Simply put, adding additional quarters to the same table would not increase
the number of fields. One field would indicate to which quarter any
particular record belongs.

Glenn

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of timdbui
Sent: Monday, May 20, 2013 9:19 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Linking Tables Question (Junction Table ?)

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
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of timdbui
> Sent: Monday, May 20, 2013 8:57 AM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.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]
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

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

__,_._,___

Tidak ada komentar:

Posting Komentar