Use query to search four tables

[templeowls]

I have four databases that are full of incidents over a given year (2015-2019). The tables have the exact same columns. I've successfully made a parameter query for the 2019 table that lets me pull entries in the table that match the employee ID field, which is so useful. I was wondering if its possible to have this query search all four databases in the same manner.



Any walk through online seems to explain how to pull different data sets from various tables. I need the same data from each table; just based on the ID parameter I type in.

[JoeM]

If all four tables are structured exactly the same, you can create a Union query to combine them all in to one big query.
See here for how to do that: http://access-excel.tips/union-and-u...-access-query/

Then you can simply just query this one, big query.

[templeowls]

That makes sense. I'll try that. Thanks!!

[JoeM]

You are welcome.