Query All Records / Tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to search for a unique ID across all tables? All ID's are
unique throughout the database and I need to search the entire thing for a
single ID. Using Access 2003.
 
You would need to construct a UNION query that joins every table in the
database. Difficult to maintain if you are adding new tables and will run
slow.

Why do you have unique ID's which you need to search in multiple tables? Are
you doing something like a table for each month or each piece of equipment?
If so, that's the main problem. All like items should be in the same table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a distinct Join 3
Query Assistance 3
Is record time field value > n min after the next rec ID 5
Query to create multipe total fields 7
Access 2000 append unbound text box values to a table 0
Flag First Record 2
query to filter by current record id? 4
Delete Query: Could not delete from specified tables 0

Back
Top