Joan Wild/John Vinson

  • Thread starter Thread starter Omar
  • Start date Start date
O

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
 
In addition, when I try to open the report, which again
was created from this querie, it prompts me four times for
the dates.
Click to expand...

That certainly sounds like the Form is not open at the time you're
opening the Report. Is it?
 
Back
Top