|
Subject:
|
CrossTabs and parameters.
|
|
Posted By:
|
china99boy
|
Post Date:
|
4/14/2006 12:38:10 PM
|
Please help, I have a 2 crosstab queries which I need to join to make one query with both results. They work fine seperately and has a parameter to show only results for a required month. All my data is in one table which includes a date field. I cannot for the life of me get the both the crosstab into one query when the paremeter is set on the crosstabs. Without the paremeters I can join, but then I do join the crosstabs with out the paremeters set, I cannot add the paremter to the joint crosstab query because the date field was removed from the crosstabs paremeter.
PARAMETERS [Enter Month] Text ( 255 );
TRANSFORM Sum(APPROACH.AMOUNT) AS SumOfAMOUNT
SELECT APPROACH.AO, Sum(APPROACH.AMOUNT) AS SumOfAMOUNT1, Count(APPROACH.LOAN_TYPE) AS CountOfLOAN_TYPE
FROM APPROACH
WHERE (((Format([Date_Field],"mmm"))=[Enter Month]))
GROUP BY APPROACH.AO
PIVOT APPROACH.LOAN_TYPE;
PARAMETERS [Enter Month] Text ( 255 );
TRANSFORM Count(APPROACH.AMOUNT) AS CountOfAMOUNT
SELECT APPROACH.AO, Count(APPROACH.AMOUNT) AS [Total Of AMOUNT]
FROM APPROACH
WHERE (((Format([Date_Field],"mmm"))=[Enter Month]))
GROUP BY APPROACH.AO
PIVOT APPROACH.LOAN_TYPE;
These are my results from the both crosstabs. Please help my join them and be able to still use the paremeter query for the date.
|
|
