Cross Tab Query

[rishi_375]

Hi,
How can i pass Cross tab query Parameter value from Forms object, as i try to generate recordset?


Following query i have written :

PARAMETERS [Forms]![frmParamSummaryReport]![txtFromDate]![Value] Long;
TRANSFORM Sum([Usage].[UsageValue]) AS [SumOfThe Value]
SELECT [Usage].[ST_DATE] AS STDate, format([Usage].[ST_DATE],'mmm yy') AS [Month]
FROM Usage
WHERE [Usage].[ST_DATE]<=[Forms]![frmParamSummaryReport]![txtFromDate]!Value
GROUP BY [Usage].[ST_DATE], DatePart('m',[Usage].[ST_DATE])
PIVOT [FY];

and in Form i call this query and in the txtFromDate is Text box.


Please advise.
Thanks.

 

[Pat Hartman]

See this post for a DAO solution.

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=176367#post176367