Append Querys into a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two queries that I can append into a table. But that forces me to run
them everytime the data is changed. Is there a way where I could have the
results in a query not a table?

Query 1 looks like:

Key aPAED aRWC aRTL aCCA Type
01-26200 9.10 24.33 0.00 45.63 Curent
01-27681 11.97 0.00 19.40 36.50 Curent
01-29030 3.07 26.30 0.00 24.37 Curent

Query 2 Looks like:

Key bPAED bRWC bRTL bCCA Type
01-26200 9.10 24.33 0.00 45.63 Base
01-27681 11.97 0.00 13.27 36.50 Base
01-29030 5.10 26.30 0.00 24.37 Base

Resulting Query needs to look like:

Key Type PAED RWC RTL CCA
01-26200 Base 9 24 0 46
01-26200 Cur 9 24 0 46
01-27681 Base 12 0 13 36
01-27681 Cur 12 0 19 36
01-29030 Base 5 26 0 24
01-29030 Cur 3 26 0 24

Thank You
 
I have two queries that I can append into a table. But that forces me to run
them everytime the data is changed. Is there a way where I could have the
results in a query not a table?

Query 1 looks like:

Key aPAED aRWC aRTL aCCA Type
01-26200 9.10 24.33 0.00 45.63 Curent
01-27681 11.97 0.00 19.40 36.50 Curent
01-29030 3.07 26.30 0.00 24.37 Curent

Query 2 Looks like:

Key bPAED bRWC bRTL bCCA Type
01-26200 9.10 24.33 0.00 45.63 Base
01-27681 11.97 0.00 13.27 36.50 Base
01-29030 5.10 26.30 0.00 24.37 Base

Resulting Query needs to look like:

Key Type PAED RWC RTL CCA
01-26200 Base 9 24 0 46
01-26200 Cur 9 24 0 46
01-27681 Base 12 0 13 36
01-27681 Cur 12 0 19 36
01-29030 Base 5 26 0 24
01-29030 Cur 3 26 0 24

Thank You
Click to expand...

Yes: a UNION query is just the ticket for this. See UNION in the
online help - post back if it's confusing. Your're transforming the
data in addition to stringing it together so I'm not certain just what
you mean (how do you decide to truncate the length of the Type field
for example?)

John W. Vinson[MVP]
 
Back
Top