Global Name Query

[jboomer]

I need to creat a global Name Query. I have 4 Tables. Each table has a Unique Name and a name Field, Such as:

Table: Parents
Field: Parents name

Table: Students
Field: Student Names

I need to Create a Query That just has one Field Call Name.

And i need it to pull all the names from the name field in all 4 tables.

PLease help.

 

[KeithG]

You need a union query

Select [Parents Name] as Name from tblParents
Union
Select [Stundents Name] as Name from tblStundents


the above would return every stundent name and parent name from both tables.