one record from multiple tables

[HabaneroRick]

I've got three seperate tables that all list a license plate number. I'm trying to run one query attached to a form to be able to search all tables for one license plate number. So far I can't even get the query to run correctly. Any ideas?

 

[John Big Booty]

Welcome to the forum.

Without seeing the structure of your tables and queries it is going to be very difficult to diagnose your problem.

Any chance of anonamising your data and posting a copy?

 

[Dairy Farmer]

Create 3 identical tables
Create a Make Table query using Table1 to Table4
Create 2 Append Table queries from Table2 and Table3 to Table4

Run first query, then second and third queries.
Table4 now has all three tables in one.
Table4 is a temp table. Any edits to data are not appended to the origionals.

Suggestion:
Add a column to each query that has the table name. This can be used to open that table.