Building a query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Les (anonymous_at_discussions.microsoft.com)
Date: 09/03/04 

Date: Fri, 3 Sep 2004 08:10:17 -0700

David,

   It looks like your situation is a little more
complicated than your first post suggested.
   How do TestingStudentInfo and TestingDataTbl relate to
each other? Likewise, how do PlacementStudentInfoTbl and
placementDataTbl relate to each other?
   Does TestingStudentInfo contain information about
students and TestingDataTbl contain information about
tests that students have taken? Do they relate by a
TestId or something?
   I guess some more info. would be helpful. Maybe you
could list column names in tables?

  
 
>-----Original Message-----
>Thank you for the reply.
>
>I came up with this, but each record replicates itself 4
>times.
>
>SELECT StudentID, Fname, Mi,
>lname,StartTestTime,AllowedTime,ExpTime,Proctor
>
>FROM TestingStudentInfo,TestingDataTbl;
>
>UNION SELECT StudentId, Fname, Mi,
>lname,StartTestTime,AllowedTime,ExpTime,Proctor
>
>FROM PlacementStudentInfoTbl, placementDataTbl;
>
>Thank You for your help so far.
>
>>-----Original Message-----
>>David,
>> I think you want to build a union query. Try looking
>>up Union Query in the online help feature of Access. It
>>should walk you through the process.
>>
>>>-----Original Message-----
>>>Hello,
>>>
>>>If anyone could help me with this one. I have two
feilds
>>>of data in two seperate tables. The feilds are
similiar
>>>and I would like them to appear in the same feild in
one
>>>of the queries.
>>>
>>>Any help would be great.
>>>
>>>David Ehrenriech
>>>
>>>.
>>>
>>.
>>
>.
>