Searching Multiple Tables...

[Trevor]

Hello All,

I have set up a form that returns the results of a query
based on user's input. However, now I need to have the
query somehow search for the data in two separate, but
similar tables. How does the query work for this type of
thing? Let's assume the two tables have the same
structure and field headings.

For example, user inputs an invoice number and the form
displays every occurrence of that number and all of its
relevant info( i.e., date, dollar amt, etc. ). Now, I
need it to look in both tables to find that invoice number
and relevant data.

Any help is much appreciated.

Thanks.

 

[Duane Hookom]

You may be able to create a UNION query of the two tables. Then search the
union query.