Script for Reports (How to get a new found set for different reports)
Dear Forum Users
I have a problem with writing an effective script for a report.
In my database, the table which holds the data is called CLIENTS. I have 2 report problems. 1 report "Referral Source Totals" runs a report on ALL the Clients, the other "Referral Source 2006" runs a report on the Clients of 2006. Both work but only if I go to the original table (CLIENTS) and click on "Show All (Records)" followed by "Unsort (records)". I cannot swop from one report to another without going back to the table & carrying this out show/unsort each time; if I fail to do this, the report runs on the previous found set (I think) & produces incorrect information.
I've done my best to sort this out but failed. Is there a way of writing a script which wi automate this process?
I should be very grateful for any help.
E M Harvey