That's perfect! Your suggestion worked great! Thanks. |
From: Duane Hookom <duanehookom@hotmail.com>;
To: Access Professionals Yahoo Group <ms_access_professionals@yahoogroups.com>;
Subject: RE: [MS_AccessPros] Searching multiple tables
Sent: Wed, May 7, 2014 2:13:43 AM
|
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? |
__._,_.___
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
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