"Find" in Access 2000 - Multiple tables

  swapper 08:01 30 Mar 08

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 08

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

  Woolwell 18:50 30 Mar 08

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 08

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.

Sniper Elite 4 review: Headshotting Nazis has never felt so good

1995-2015: How technology has changed the world in 20 years

The Fresh New Fonts of 2017

WWDC 2017 dates: How to get WWDC 2017 tickets, when is WWDC 2017 and more details announced