Using same report

[TheCandyman]

I have a report setup that pulls info from a query. No problems with it. I have another query with the same data, but different filters. How can i change my report to pull from this other query. I don't want to make a new report from scratch, seems like a waste of time.

 

[smedvid]

"One" approach is to use the built-in filter option of OpenReport. Review the help for examples. I don't have any on hand.

Another less desirable option may be to change the reports "Record Source" to point to the specific query that you have defined. I have never used this option, but seems like it can be done...

hthw,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[sync123]

Hi,

In the onOpen event of your report..
----------------
if(somecriteria) then
Me.recordSource="qry_1"
else
Me.recordSource="qry_2"
end if
-------------------
where qry_1 and qry_2 are names of queries in your database.

Doing so sets the record source of your report to the particular qry that u want to work with.

Hope this helps.
sync123