Parameter Querie

[Omar]

Thanks for the responds. I tried to do this and the querie
works fine, but when I try to open or print the report
created from that querie, it does not work. I receive this
error:
"The microsoft jet engine does not recognize " as a valid
name or expression."

In addition, when I try to open the report, which again
was created from this querie, it prompts me four times for
the dates.

So i assumed that something was wrong with report, and I
tried to create another report based on this querie but
access report wizard does not show any fields under the
querie.

Troubleshooting, I found that the caused of this problem
is attributed to typing [Forms]![Print_selection]!
[start_date] into the parameter menu. What can I do? Thanks

RESPONDS
Crosstab queries require their parameters to be defined.
In design view go
to Query, Parameters and put
[Forms]![Print_selection]![start_date] in the first cell,
and set the data
type to date/time
[Forms]![Print_selection]![end_date in the second row, and
set it to
date/time


QUESTION

 

[Joan Wild]

You need to open your form, fill in the textboxes with valid dates, and then
open your report (I'd suggest you put a command button on the form to open
the report).

--
Joan Wild
Microsoft Access MVP

Thanks for the responds. I tried to do this and the querie
works fine, but when I try to open or print the report
created from that querie, it does not work. I receive this
error:
"The microsoft jet engine does not recognize " as a valid
name or expression."

In addition, when I try to open the report, which again
was created from this querie, it prompts me four times for
the dates.

So i assumed that something was wrong with report, and I
tried to create another report based on this querie but
access report wizard does not show any fields under the
querie.

Troubleshooting, I found that the caused of this problem
is attributed to typing [Forms]![Print_selection]!
[start_date] into the parameter menu. What can I do? Thanks

RESPONDS
Crosstab queries require their parameters to be defined.
In design view go
to Query, Parameters and put
[Forms]![Print_selection]![start_date] in the first cell,
and set the data
type to date/time
[Forms]![Print_selection]![end_date in the second row, and
set it to
date/time


QUESTION

I have a crosstab querie whose criteria is set to:

Between [Forms]![Print_selection]![start_date] And [Forms]!
[Print_selection]![End_date]

This line of code is suppose to get inputs for a between
[start date] and [end date] command from a set of
controls on a print form. But I get an error, even after I
set the value of end_date and start_date on the parameter
menu as date\time.

The error reads:

Microsoft Jet Enginee.. Does not recognize [Forms]!
[Print_selection]![start_date]

Any suggestions, thanks..