By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,758 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Multiple Fields, Similar Data

P: n/a
The MS Access website is very unhelpful on this topic, and I cannot
find anything in my Googling to find a hint.

I am working with very large, existing data sets that consist of
multiple fields. Two of the fields are "Origin" and "Destination".
These fields contain the FAA Airport Codes, so the data is similar. I
also have another table with all FAA Airport Codes, corresponding FAA
Airport Categories, and Airport Names.

I need to establish the relationship between the main air travel table
and the airport table. Both the "Origin" and "Destination" must relate
to the FAA Airport Code table. However, when I establish this
relationship and examine the FAA Airport Code table, I get the
equivalent of an "and" function. In other words, the only records in
the subtables are those flights that both originated and terminated at
the SAME airport (aka "sightseeing" flights...) What I need is the
records of ALL flights that EITHER originated OR terminated at the
specified Airport.

All the Microshaft website says is "don't do that".
I am a novice, and any clue would be helpful.

TIA

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If I understand your application correctly, you need to link to two
separate instances of the codes table. In your query, add a separate
instance of that table. Then link the travel table to the first
instance by the origin code, and to the second one by the destination
code. Then you can create an OR filter using the fields from the two
copies of the codes table.

Nov 13 '05 #2

P: n/a
"PPT33R" <mt*******@usa.com> wrote in
news:11**********************@z14g2000cwz.googlegr oups.com:
The MS Access website is very unhelpful on this topic, and I
cannot find anything in my Googling to find a hint.

I am working with very large, existing data sets that consist
of multiple fields. Two of the fields are "Origin" and
"Destination". These fields contain the FAA Airport Codes, so
the data is similar. I also have another table with all FAA
Airport Codes, corresponding FAA Airport Categories, and
Airport Names.

I need to establish the relationship between the main air
travel table and the airport table. Both the "Origin" and
"Destination" must relate to the FAA Airport Code table.
However, when I establish this relationship and examine the
FAA Airport Code table, I get the equivalent of an "and"
function. In other words, the only records in the subtables
are those flights that both originated and terminated at the
SAME airport (aka "sightseeing" flights...) What I need is the
records of ALL flights that EITHER originated OR terminated at
the specified Airport.

All the Microshaft website says is "don't do that".
I am a novice, and any clue would be helpful.

TIA

I don't know how you are trying to build your joins, but if using
the query builder, try this.

open a new query in design mode. Add the travel table. Add the
airport table twice. Link the link between the Origin field to
one of the two airport tables. Link the Destination field to the
other airoport table.
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.