Simple Query Question, can't figure it out
in [Queries]
|
From: bswood7 on 10 Jul 2008 09:56 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
From: Michel Walsh on 10 Jul 2008 10:22 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" <bswood7(a)discussions.microsoft.com> wrote in message news:8105D633-D90C-4D19-BBE8-6C2B43147250(a)microsoft.com... > 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
From: bswood7 on 10 Jul 2008 10:46 Awesome. Thanks, that was so easy! I never would have figured it out though. ~Brandy "Michel Walsh" wrote: > 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" <bswood7(a)discussions.microsoft.com> wrote in message > news:8105D633-D90C-4D19-BBE8-6C2B43147250(a)microsoft.com... > > 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 > > >
|
Pages: 1 Prev: Module problems Next: A couple of text parsing questions |