Crosstab Query: Invalid Bracketing of name...

[rogerarce]

I have a crosstab query for orders. In the crosstab I have
the following fields:
Customer
Product
Size
Ship Week
Year

To get my information I have some criterias. The problem
I have is in the ship week parameter. The criteria I use
is: Between [Starting ship week] And [Ending ship week],
if I do not put it in the parameters nothing happens and
I do not get the info. If I put it in the parameters it
returns the message:
Invalid bracketing name '[between [Starting ship week] And [Ending ship week]]'.
If I do not use between + and, and I only use a single
parameter like [Starting ship week] it works fine, but I
need to know the orders between one date and another.
Thanks in advance for your help.

Roger

 

[sko]

I think the problem is you're entering the parameter all in one line. Try this:

[Starting ship week] datatype
[Ending ship week] datatype

 

[rogerarce]

Sko:
Thank you for your information. It did not work as I wanted
because I was getting info only for 2 ship weeks like:
20 and 25 and not 20,21...25. The good thing is that I
did as you said and tried the parameters and in the field for the ship week I wrote the Between And criteria and worked great!

Thanks again
Roger