Name Search Multiple Fields (1 Viewer)

[eholtman]

A old nemish as resurfaced that I found a work around in the past but I dont want to go thru that again. So looking for any help on:

In the same query (CMEC.Ticket) I have 3 tables named:

NME_IMPLMT
NME_SBT
NME_RQSTR

I want to see all records if the name of "JohnDoe" matches one of the tables.

Any direction would be appreciated

 

[jfgambit]

Have a look at the following example. You'll need to manipulate the code to search each table individually, but this should get you started in the right direction. A sample database is included from John Big Booty

http://www.access-programmers.co.uk/forums/showthread.php?t=188663&highlight=search+multiple+tables