creating a parameter value in a crosstab query

  • Thread starter Thread starter stella
  • Start date Start date
S

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!
 
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!
Click to expand...

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.
 
Back
Top