an easy question

[tool2269]

right now i'm working with just one table
for example:

field1 - field2
george - austin
george - dallas
sarah - houston
john - austin
stacey - dallas

how do i set up a query so that when i search for BOTH dallas and austin people, it shows me their names.. and doesnt list their names multiple times

 

[Jewellissa]

Easy Question ??

I didn't find this an easy question.. but I thought about it for a little.. I think some of the problem is because you dont appear to have a Key value or if you do it probably wont help you much in this query. So here is ueber brilliant way to do it.. OKay maybe not..

If you have Access 2000+...

-Create a Make-Table Query of all the ppl from Houston

-Create a Make-Table Query of all the ppl from Dallas

-Create a Find Duplicates Query on both those tables

Voila!

I am ALMOST POSITIVE that Find Duplicates Query were first intro'd in 2000.

Good Luck! If you have less than 2000.. ask again..
Pooh Bear: "Think..Think..think..."

Jewelz