multiple search

[gilly]

Could some-one please tell me how to do a multiple search across various tables within the one database????????
Thanks!

[Gary.Lowe]

Gilly

Post an example of what it is you want to do

[Jimmer]

You Can Just Use A Select Statement Like This:

"Select [fld1].[table1],[fld2].[table1],[fld3].[table2],
[fld4].[table2] From [table1],[table2] Where [fld4].[table1]
= '" & setValue & "'"

Hope This Helps.

[asad_s23]

HI! YOU QUESTION IS NOT CLEAR,IF YOU CAN EXPLAIN A LITTLE BIT MORE THAT WHAT DO YOU WANT TO DO EXACTLY,THEN HOPEFULLY I CAN HELP YOU..
SEND ME THE REAL SITUATION THAT YOU WANT TO PROGRAM.
WAITING FOR YOUR REPLY