Building a query

[David]

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

 

[Les]

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.

 

[David]

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.

 

[Les]

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?