Name?
It would help if you provided some information about the tables. Are the structures the same? Do you want to search a single field in each table?
Assuming the tables have the same structure and you have a single field to search, create a union query of all three tables and search the results of the single field.
Duane Hookom MVP
MS Access
From: k2j1203@yahoo.com
I don't know if this is possible. I need to create a query that will search 3 different tables based for one item. I have 3 tables linked from 3 different databases - one for per department. All departments have events that they go to. I want to be able to search all three tables to see if any of them are already attending an event. Is there a way to do this without creating 3 separate queries?
It would help if you provided some information about the tables. Are the structures the same? Do you want to search a single field in each table?
Assuming the tables have the same structure and you have a single field to search, create a union query of all three tables and search the results of the single field.
Duane Hookom MVP
MS Access
From: k2j1203@yahoo.com
I don't know if this is possible. I need to create a query that will search 3 different tables based for one item. I have 3 tables linked from 3 different databases - one for per department. All departments have events that they go to. I want to be able to search all three tables to see if any of them are already attending an event. Is there a way to do this without creating 3 separate queries?
__._,_.___
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Now you can search Photos & Files in your Group !
You can now search for photos and files in your Yahoo Group, in addition to searching for messages in your Group archive
.
__,_._,___
Tidak ada komentar:
Posting Komentar