"Find" in Access 2000 - Multiple tables

  swapper 08:01 30 Mar 2008
Locked

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.

tia

  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

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone