Union Queries
- From: "Penny" <Penny@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 22 Jun 2005 07:39:03 -0700
I converting my database from 97 to 2003 and now my union queries don't work.
Can you tell me why? The below is the message I get. Thanks in advance for
any help.
"This expression is typed incorrectly, or it is to complex to be evaluated.
For example, a numeric expressoin may contain to many complicated elements.
Try simplifying the expression by assigning parts of the expression to
variables."
This is my code:
SELECT [Test 1].[Customer Name], [Test 1].[Relationship Manager], [Test
1].[Line of Business], [Test 1].[Division Head Last Name Only], [Test
1].[Real Estate Market], [Test 1].[Year],Null AS DerivativeFees1, Null AS
AgencyFee2, Null AS IncrementalFeeIncome3, Null AS GrandTotals4,Null AS
SubDebt5
FROM [Test 1]
Union
SELECT qrySumOfDerivativeFeesDivisionHeadRE.[Customer Name],
qrySumOfDerivativeFeesDivisionHeadRE.[Relationship Manager],
qrySumOfDerivativeFeesDivisionHeadRE.[Line of Business],
qrySumOfDerivativeFeesDivisionHeadRE.[Division Head Last Name Only],
qrySumOfDerivativeFeesDivisionHeadRE.[Real Estate Market],
qrySumOfDerivativeFeesDivisionHeadRE.[Year],Sum(qrySumOfDerivativeFeesDivisionHeadRE.NPV)
AS DerivativeFees1, Null AS AgencyFee2, Null AS IncrementalFeeIncome3, Null
AS GrandTotals4,Null AS SubDebt5
FROM qrySumOfDerivativeFeesDivisionHeadRE
GROUP BY qrySumOfDerivativeFeesDivisionHeadRE.[Customer Name],
qrySumOfDerivativeFeesDivisionHeadRE.[Relationship Manager],
qrySumOfDerivativeFeesDivisionHeadRE.[Line of Business],
qrySumOfDerivativeFeesDivisionHeadRE.[Division Head Last Name Only],
qrySumOfDerivativeFeesDivisionHeadRE.[Real Estate Market],
qrySumOfDerivativeFeesDivisionHeadRE.[Year],Null, Null, Null,Null
Union
SELECT qrySumOfAgencyFeesDivisionHeadRE.[Customer Name],
qrySumOfAgencyFeesDivisionHeadRE.[Relationship Manager],
qrySumOfAgencyFeesDivisionHeadRE.[Line of Business],
qrySumOfAgencyFeesDivisionHeadRE.[Division Head Last Name Only],
qrySumOfAgencyFeesDivisionHeadRE.[Real Estate Market],
qrySumOfAgencyFeesDivisionHeadRE.[Year],Null AS DerivativeFees1, Sum([Agency
Fee]) AS AgencyFee2, Null AS IncrementalFeeIncome3, Null AS GrandTotals4,Null
AS SubDebt5
FROM qrySumOfAgencyFeesDivisionHeadRE
GROUP BY qrySumOfAgencyFeesDivisionHeadRE.[Customer Name],
qrySumOfAgencyFeesDivisionHeadRE.[Relationship Manager],
qrySumOfAgencyFeesDivisionHeadRE.[Line of Business],
qrySumOfAgencyFeesDivisionHeadRE.[Division Head Last Name Only],
qrySumOfAgencyFeesDivisionHeadRE.[Real Estate Market],
qrySumOfAgencyFeesDivisionHeadRE.[Year],Null, Null, Null,Null
Union
SELECT qrySumOfSyndicationFeesDivisionHeadRE.[Customer Name],
qrySumOfSyndicationFeesDivisionHeadRE.[Relationship Manager],
qrySumOfSyndicationFeesDivisionHeadRE.[Line of Business],
qrySumOfSyndicationFeesDivisionHeadRE.[Division Head Last Name Only],
qrySumOfSyndicationFeesDivisionHeadRE.[Real Estate Market],
qrySumOfSyndicationFeesDivisionHeadRE.[Year],Null AS DerivativeFees1, Null AS
AgencyFee2, Sum(qrySumOfSyndicationFeesDivisionHeadRE.[Incremental fee
income]) AS IncrementalFeeIncome3, Null AS GrandTotals4,Null AS SubDebt5
FROM qrySumOfSyndicationFeesDivisionHeadRE
GROUP BY qrySumOfSyndicationFeesDivisionHeadRE.[Customer Name],
qrySumOfSyndicationFeesDivisionHeadRE.[Relationship Manager],
qrySumOfSyndicationFeesDivisionHeadRE.[Line of Business],
qrySumOfSyndicationFeesDivisionHeadRE.[Division Head Last Name Only],
qrySumOfSyndicationFeesDivisionHeadRE.[Real Estate Market],
qrySumOfSyndicationFeesDivisionHeadRE.[Year], Null, Null, Null,Null
UNION SELECT qrySumOfOtherFeesDivisionHeadRE.[Customer Name],
qrySumOfOtherFeesDivisionHeadRE.[Relationship Manager],
qrySumOfOtherFeesDivisionHeadRE.[Line of Business],
qrySumOfOtherFeesDivisionHeadRE.[Division Head Last Name Only],
qrySumOfOtherFeesDivisionHeadRE.[Real Estate Market],
qrySumOfOtherFeesDivisionHeadRE.[Year], Null AS DerivativeFees1, Null AS
AgencyFee2, Null AS IncrementalFeeIncome3,
Sum(qrySumOfOtherFeesDivisionHeadRE.[Grand Total]) AS GrandTotals4,Null AS
SubDebt5
FROM qrySumOfOtherFeesDivisionHeadRE
GROUP BY qrySumOfOtherFeesDivisionHeadRE.[Customer Name],
qrySumOfOtherFeesDivisionHeadRE.[Relationship Manager],
qrySumOfOtherFeesDivisionHeadRE.[Line of Business],
qrySumOfOtherFeesDivisionHeadRE.[Division Head Last Name Only],
qrySumOfOtherFeesDivisionHeadRE.[Real Estate Market],
qrySumOfOtherFeesDivisionHeadRE.[Year], Null, Null, Null,Null
UNION SELECT qrySumOfSubDebtRevenueDivisionHeadRE.[Customer Name],
qrySumOfSubDebtRevenueDivisionHeadRE.[Relationship Manager],
qrySumOfSubDebtRevenueDivisionHeadRE.[Line Of Business],
qrySumOfSubDebtRevenueDivisionHeadRE.[Division Head Last Name Only],
qrySumOfSubDebtRevenueDivisionHeadRE.[Real Estate
Market],qrySumOfSubDebtRevenueDivisionHeadRE.[Year],Null AS DerivativeFees1,
Null AS AgencyFee2, Null AS IncrementalFeeIncome3, Null AS
GrandTotals4,Sum(qrySumOfSubDebtRevenueDivisionHeadRE.[SubDebt]) AS SubDebt5
FROM qrySumOfSubDebtRevenueDivisionHeadRE
GROUP BY qrySumOfSubDebtRevenueDivisionHeadRE.[Customer Name],
qrySumOfSubDebtRevenueDivisionHeadRE.[Relationship Manager],
qrySumOfSubDebtRevenueDivisionHeadRE.[Line Of Business],
qrySumOfSubDebtRevenueDivisionHeadRE.[Division Head Last Name Only],
qrySumOfSubDebtRevenueDivisionHeadRE.[Real Estate
Market],qrySumOfSubDebtRevenueDivisionHeadRE.[Year],Null, Null, Null,Null;
.
- Prev by Date: Counting distinct entries within groups please help
- Next by Date: Update Query Help
- Previous by thread: Counting distinct entries within groups please help
- Next by thread: Update Query Help
- Index(es):
Relevant Pages
|
