If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Querying from multiple tables - newbie question
I hope the following provides all the information for people to help
me with this problem: The database: Using Access 2002 tracks containers shipped from our two factories abroad. Each factory's shipping information is continued in its own table (i.e. 2 tables of data). The tables are very similar except for a few fields which are unique to each as the two factories handle their shipping slightly differently. The primary end user frequently runs queries to provide him with the list of containers awaiting shipment, currently on the water, in customs etc. The query results are returned to standard datasheets. I am trying to design a simple query which can combine these and return the results in one. So, for example, I want one query which, when run, searches both Factory A and Factory B's tables and returns a datasheet of all those with the status "Arrived". Searching either is easy but I have been completely unable to find away to find a way to search both tables with one query and return the results in one worksheet. Any help (desperately) appreciated. |
#2
|
|||
|
|||
Answered in comp.databases.ms-access
|
#3
|
|||
|
|||
On Thu, 26 Aug 2004 21:09:58 +0800, "Allen Browne"
wrote: Answered in comp.databases.ms-access Thanks. I've posted a response there explaining why it is being done the way it is. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Starting over with appending data from one flat table to multiple relational tables. | Stranger | Running & Setting Up Queries | 1 | August 5th, 2004 04:32 AM |
updating multiple tables | Sunny | Using Forms | 2 | July 30th, 2004 06:08 PM |
Fields from multiple Tables on 1 Form | Alan Armitage | Using Forms | 2 | July 15th, 2004 11:13 AM |
Access...multiple tables vs many null fields | TravisR | General Discussion | 7 | July 7th, 2004 09:48 PM |