Could some-one please tell me how to do a multiple search across various tables within the one database????????
Thanks!
Printable View
Could some-one please tell me how to do a multiple search across various tables within the one database????????
Thanks!
Gilly
Post an example of what it is you want to do
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.
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