2 questions on input parameters

[accessmatt]

Is there a way to use a parameter in a CrossTab query? I get a 3070 error when I use it here, however it works fine on a regular query.



http://office.microsoft.com/en-us/ac...080761289.aspx

Also, is it possible to use a range in a query parameter (i.e. all dates between this range). If so, how?

[pbaldy]

You already have your answer: the parameters must be declared in the parameters box. Maybe this will also help:

http://allenbrowne.com/ser-67.html

[accessmatt]

This is great - thank you for that link!

Is there a way to use a parameter in a CrossTab query? I get a 3070 error when I use it here, however it works fine on a regular query.

http://office.microsoft.com/en-us/ac...080761289.aspx

Also, is it possible to use a range in a query parameter (i.e. all dates between this range). If so, how?

[pbaldy]

Happy to help!