Assigning a Report to a query

[Tumby]

I have a query that when run shows an imput box for dates from and to.

What I want to do is assign this query to a report.
If I try to append the query, the append list is tables only, not reports.

HELP!!!

 

[Brianwarnock]

I don't understand your post.

I have a query that when run shows an imput box for dates from and to.

Do you mean that when the query runs you get prompted for parameters?

What I want to do is assign this query to a report.

Reports are based on queries, ok some people base them on tables but this is not a good idea as you cannot apply selective criteria, do many data manipulation techniques, join other tables etc. When you create a report you select which query to base it on.

Brian

 

[Tumby]

Thanks for the help!

Yes I do get parameters when the query is run.

Oh! I had already created the report.

If I redo it and select the query, will that work?

 

[Brianwarnock]

You must base the report on the query, then the selection made in the query will apply.
When you run the report the query is run by the system.

Brian