Simple Query Question, can't figure it out

[bswood7]

Hello,

Novice user here. I have two tables. One contains StudentName,
ProgramSelect1, ProgramSelect2, ProgramSelect3 and a variety of other fields.
The second table contains Contact information for Programs (Program,
ContactName, Email, Location, Phone).

I want to create a query that gives me the StudentName and the contact
information for each of their Program Selections. So the query would return
ContactName, Email, Location, and Phone for each of their 3 selections.

Please help!

~Brandy

 

[Michel Walsh]

Your design is not totally normalized, but you can proceed like this:

Make a new query, bring the table One once, and table Second, three times.

In the graphical part of the query designer:
Drag One.ProgramSelect1 over one of the table Second, over its field
ProgramName.
Drag One.ProgramSelect2 over another of the table Second, field ProgramName
Repeat for One.ProgramSelect3 over the last table Second, field ProgramName

In the grid, drag the fields you need.



Vanderghast, Access MVP

 

[bswood7]

Awesome. Thanks, that was so easy! I never would have figured it out though.

~Brandy