A very simple on but a little unsure how to tackle this.
I have a report that has around 6 tables all related. I am only interested in data after the 1st November, so the 5/6 years od data prior is not needed. Now I can filter the report etc, but is there a way stop queries looking at this dtaa in the first place. I know how to do this on a per table basis but it stll look at the all reocrds for other tables.