unwanted parameter on report

[ChipF]

I created a report that runs from a query with a parameter in it. I no longer want that parameter to run on this report. The query is linked to 3 other reports so I don't want to change the query. Is there a properties tab or something in reports that can eliminate parameters?

Chip

 

[GoDawgs]

Just make a copy of the query without the parameter...then link your report to the no-parameter version instead of the other one. Hope that helps.

Kevin

 

[ChipF]

Ok, my question is how do you link the report to the new query? I have another query with no parameter but I still have the list box from the old query, how do you change that?

Chip

 

[GoDawgs]

I might be confused here...you've got a query and a report right? If you change the datasource of the report to this new query (which is the same as the old one minus the criteria that the user was responsible for) then you should be able to run the report and return all the records. Let me know what I missed.

Kevin

 

[ChipF]

I just don't know how to change the datasource, is there a button for that? I have Access 97. Thanks

Chip

 

[ChipF]

Ok, I found it, thanks for your help Kevin.

 

[GoDawgs]

Ok, gotcha...sorry I didn't explain that better. Glad you got it though...