Crosstab query with Date() function GeorgeMar 06.07.2006 09:02:01 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

Re: Crosstab query with Date() function "Alex Dybenko" <alexdyb[ at ]PLEASE.cemi.NO.rssi.SPAM.ru> 07.07.2006 06:07:56 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 "GeorgeMar" <GeorgeMar[ at ]discussions.microsoft.com> wrote in message news:9E07FEE2-C10C-4E28-9EBA-938E31A1A253[ at ]microsoft.com... [Quoted Text] >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 >