Multipule Tables

[Delaina Lyons via AccessMonster.com]

Hi,
I have a query that sorts through one table to produce a form, but I need to
somehow make the same query produce the form from 2 tables. The query
basically sorts the information and has not criteria for one column..I have
no clue on how to get the query to run off of both tables. Thanks!

 

[Duane Hookom]

I'm not at all sure what you have and what you need. Queries don't "produce
the form" from tables.

Are both table the same structure?
Do you want to change the record source from one table to the other?
Are your tables related?

 

[Guest]

Delaina:
Try creating a UNION query of the two tables, using the AS keyword to rename
the fields you want to have sorted as the same, if necessary, then create
another query that uses this query in the FROM clause (with the field you
want sorted in the ORDER BY clause).
Most people seem to forget that you are allowed to create a query based on
another query.