R
Ryan
I know this question has been asked 100 times, however, I still have not seen
a solution. Here is my crosstab query.
PARAMETERS [Forms]![Parameters].[LocationFilter] Text ( 255 ),
[Forms]![Parameters].[StartDateFilter2] Text ( 255 ),
[Forms]![Parameters].[EndDateFilter2] Text ( 255 );
TRANSFORM Sum(AllCharges.BalDue) AS SumOfBalDue
SELECT AllCharges.FinClass, Sum(AllCharges.BalDue) AS [Total Of BalDue]
FROM AllCharges
WHERE (((InStr("," & Forms!Parameters.LocationFilter & ",","," & [db] &
","))>0))
GROUP BY AllCharges.FinClass
ORDER BY AllCharges.FinClass
PIVOT AllCharges.DB;
I have seen many posts telling people to switch to reports, which will not
work for me. As you can see from my query, my row headings will be from
AllCharges.FinClass, and my row headings will be from AllCharges.DB. There
can be 1 to 72 DB's to choose from in my parameter form. I would like to
have a form open that only shows the selected DB's. I know you can name the
DB's in the PIVOT statement, for example PIVOT AllCharges.DB
IN("C28","C48","C52"), but the parameter form lets them select which DB's
they want to see so hard coding the values will not work. In the end, I
would like my form to be a continous form that only shows the select DB's
from the parameter page. I have read about hiding controls and then
adjusting the contols position to keep them together, but I have not seen a
post on how to do this. Any help on this matter would be greatly
apprieciated.
a solution. Here is my crosstab query.
PARAMETERS [Forms]![Parameters].[LocationFilter] Text ( 255 ),
[Forms]![Parameters].[StartDateFilter2] Text ( 255 ),
[Forms]![Parameters].[EndDateFilter2] Text ( 255 );
TRANSFORM Sum(AllCharges.BalDue) AS SumOfBalDue
SELECT AllCharges.FinClass, Sum(AllCharges.BalDue) AS [Total Of BalDue]
FROM AllCharges
WHERE (((InStr("," & Forms!Parameters.LocationFilter & ",","," & [db] &
","))>0))
GROUP BY AllCharges.FinClass
ORDER BY AllCharges.FinClass
PIVOT AllCharges.DB;
I have seen many posts telling people to switch to reports, which will not
work for me. As you can see from my query, my row headings will be from
AllCharges.FinClass, and my row headings will be from AllCharges.DB. There
can be 1 to 72 DB's to choose from in my parameter form. I would like to
have a form open that only shows the selected DB's. I know you can name the
DB's in the PIVOT statement, for example PIVOT AllCharges.DB
IN("C28","C48","C52"), but the parameter form lets them select which DB's
they want to see so hard coding the values will not work. In the end, I
would like my form to be a continous form that only shows the select DB's
from the parameter page. I have read about hiding controls and then
adjusting the contols position to keep them together, but I have not seen a
post on how to do this. Any help on this matter would be greatly
apprieciated.