Parameter Query and Crosstab query (1 Viewer)

[AnnPhil]

I have a crosstab query that works fine but i need it to return data for only a specific date range. I tried entering a paramerter in the date field but the crosstab query couldn't handle it. I then created two queries basicly created a simple query that had the parameter and then a second query, a crosstab query, and based it on the first, still no luck.

Any suggestions would be appreciated.

Thanks

 

[AnnPhil]

OK i found the answer in an older post, same question. works great now.

Thanks Pat!