creating a parameter value in a crosstab query

[stella]

Hi all!

I have a crosstab query with a LastName column and date
headings. I wanted to create a parameter wherein user
will specify the date ranges (or at least month and year)
to run the query. How can I do this? I tried putting the
cluas e "=[Enter mm/yyyy] under the criteria of the date
heading field, but it say DB jet engine wont allow this.
Help! Thanks!

 

[John Vinson]

Hi all!

I have a crosstab query with a LastName column and date
headings. I wanted to create a parameter wherein user
will specify the date ranges (or at least month and year)
to run the query. How can I do this? I tried putting the
cluas e "=[Enter mm/yyyy] under the criteria of the date
heading field, but it say DB jet engine wont allow this.
Help! Thanks!

You ALSO need to explicitly put this in the Query's Parameters
collection. Right mouseclick the grey background of the table icons in
design view and select Parameters; copy and paste the prompt (it must
match EXACTLY) into the left column, and specify that the parameter is
of Date type.

Note also that mm/yyyy IS NOT A DATE. An Access Date/Time value is a
number, corresponding to a precise instant of time. You'll probably
need to enter the first of the month, not just the month.