creating a report based on Xtab query w/ parameter

  • Thread starter Thread starter stella
  • Start date Start date
S

stella

Hi all!

I have a crosstab query with dates as columns. I made a
parameter where users enter the month and year and the
query will only show dates/columns that fall within that
month. How do I create a report based on this query? The
wizard won't allow me to choose the fields in this query,
it comes out blank. Without the parameter, the report
will include all the dates that are in the table and not
limit it to a particular month. Is it possible that I
create the parameter in the report, instead of in the
query? If so, how do I this, and is this the actual
solution?

Help, anyone?

THANK YOU SO MUCH!
 
You'd probably best post the SQL of the Cross-Tab Query.

Larry Linson
Microsoft Access MVP
 
Here is the SQL statement for this crosstab query:

PARAMETERS [Enter mm/yyyy] DateTime;
TRANSFORM First([Employee Info Query].Code) AS FirstOfCode
SELECT [Employee Info Query].[Last Name]
FROM [Employee Info Query]
WHERE (((Format([Date],"mm/yyyy"))=[Enter mm/yyyy]))
GROUP BY [Employee Info Query].[Last Name], Format
([Date],"mm/yyyy")
PIVOT Format([Date],"mm/dd/yyyy");

Thanks so much for helping!
 
Back
Top