Crosstab query with Date() function

[GeorgeMar]

I want to create a crosstab query that has a Date() function as a criteria.
I know that I must also set the Query Paramaters for Crosstabs. When I put
Date() in the Parameter it converts Date() to [Date()].

Any suggestions on how to enter a function in the Parameter instead of a
control box?

regards
george

 

[Alex Dybenko]

Hi,
you don't need to add a parameter for date, just use it in where clause as:
WHERE [MyTable].MyDate=Date()

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com