Good day,
Is it possible to run a report from a crosstab query. I have a date criteria and it runs the first time, but when I input a new date criteria it does nt work.
This is my cose I copied from the SQL.
TRANSFORM Sum([Monthly Soc Security Payment Table].[Total Weekly Contribution]) AS [SumOfTotal Weekly Contribution]
SELECT [Monthly Soc Security Payment Table].[Last Name], [Monthly Soc Security Payment Table].[First Name], [Monthly Soc Security Payment Table].[Social Security Number], Sum([Monthly Soc Security Payment Table].Gross) AS SumOfGross
FROM [Monthly Soc Security Payment Table]
GROUP BY [Monthly Soc Security Payment Table].[Last Name], [Monthly Soc Security Payment Table].[First Name], [Monthly Soc Security Payment Table].[Social Security Number]
PIVOT [Monthly Soc Security Payment Table].[Begin Date];
The report keeps locked in to the first criteria.
Thanks