|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
March 25th, 2005, 08:40 PM
|
|||
|
|||
|
Connecting 3 Tables
Hello,
I am using Access2000 and have an ODBC connection to an Oricle Database. There are 3 tables that I link to and all have the same fields. I use an Append Query now to send them to a Fourth Table in Access. Then I query that table for the data. I would like to be able to just query all three tables without having to use an append query. The company I am doing this for had three divisions. MA01,MA02, & MA03. Now the divisions have all been combined to one district. In order to get the data for all three I have to combine the three tables. Any help would be appretiated. TIA Jack
|
|
#2
March 26th, 2005, 10:34 AM
|
|||
|
|||
|
Hey Lad!
I don't understand exactly what you mean! You need to be specific...why not posting the tables and an example of what is wanted? I wish to help you, but I need to understand the problem to do so! Good LUck ANIbal.
|
|
#3
March 28th, 2005, 09:20 PM
|
|||
|
|||
|
Connect 3 Tables
Quote:
Thanks for the reply. I was given advice as to using a Union Query. Thanks Jack
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Connecting 3 Tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
