How do I set a parameter for the criteria in a crosstab query? I have no problem in a regular query but can't get a crosstab query to recognize the parameter for a beginning and end date.
Thanks,
Randy
How do I set a parameter for the criteria in a crosstab query? I have no problem in a regular query but can't get a crosstab query to recognize the parameter for a beginning and end date.
Thanks,
Randy
Alot depends on how you are calling the query.
Is it sourced by a report? A form?
How are you trying to set the parameters?
You can create the crosstab without any parameters then bring down a date field form the underlying recordsource and apply a where condition on that field. Not forgetting to untick the column if you want to hide it.
David
I'm actually pulling the Crosstab Query from another Query that has the date parameters set up as [Enter Start Date] in the criteria. The Crosstab doesn't recognize the parameter and it won't let me set the same type of parameter under that record set in the crosstab.
I'm not very skilled at Access because I don't use it much. However, I did find a work around by creating another table and quering the information to it and then doing the crosstab query on that table. I set up a macro to delete the tables records, run an append query and then run the crosstab query so I got it working like I needed to.
I should try assigning a form to the criteria it sounds like and it might be easier.
Thanks for your help,
Randy
If you remove the date parameter from the first query but leave the date in there, then in the crosstab query include this date field and parameterise this field the cross tab should work without the need to use a temp table.
David
Thanks David...I'll give it a try.
Randy