Combining Tables

[UT227]

I have two tables that have the same type of name information. I need to make a sign in roster with all the names on them. I do not want to put all the names onto one table. I need them separate. However, I need all the names on the same roster. Having a hard time to figure out how to do that.

[June7]

Sounds like you need a UNION query.

Why must they be separate tables? Why not one table with another field to categorize the two sets?

[UT227]

I need to keep the names of people working here separate from names of those that do not

[June7]

But why two tables? Another field with a category value will allow you to filter the records into the two sets. That's much easier than building a UNION query.

[UT227]

It's a security thing I guess. Can't do it. I forgot about union queries.

[UT227]

Union query worked perfectly. Thanks.