"Find" in Access 2000 - Multiple tables

  swapper 08:01 30 Mar 2008

Microsoft Access 2000.

I have created a Database with five Tables, and it is working fine.

But is there anyway that I can use "Find" (or anything else) to search all of the tables at once, without having to go into each individual table, one at a time, and entering the search detail each time? I am mainly looking at telephone number columns which cannot all be within the same Table.


  Woolwell 16:04 30 Mar 2008

Guess that you'll have to use a query but am out of practice for your question.

  Woolwell 18:50 30 Mar 2008

I'm a bit out of date. But try this:

Create a query with your 5 tables and with the telephone number fields from each table in it.
The click Find and in the Look in Box select Query.

Hope this works.

  swapper 22:51 30 Mar 2008

Woolwell, thank you, I will give it a try, I'm not certain about queries yet, but I will come back.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?