Crosstab Parameter Queries Revisited

[Dugantrain]

Alright, I know this topic has been covered in former posts, but I'm still having trouble getting it together. I'm trying to create a crosstab query which will accept a user-defined parameter, in this case, a start date and end date. I see that each parameter must be individually defined in the crosstab; I've done that and it still doesn't work. Must parameters be defined in the select query that the crosstab is based on? Should the date be a selected field in the select query? And what is the syntax for the parameters in the crosstab?

 

[Dugantrain]

Never mind, I got it; no parameter in the select, must put parameters in the "Criteria" field as well as in the parameter dialog box of the crosstab. Seems kind of redundant, but it works. Hopefully this will help others that will undoubtedly come later needing the same info.