Seperate RecordSource for Report Footer

[sambo]

I don't suppose I can use two seperate Recordsources for the same report. I would like the Report Footer to hold just the Ship To Address of any given serial number that may be reported on. This would require using a seperate recordsource for the Footer because the Ship To address is not exactly related to the serial number table.

 

[Stew]

Why not just use a subreport? You can use a different record source for it and set any criteria for the data that will be displayed.

Paul

 

[sambo]

In the infamous words of Homer J. Simpson...
DOH!!!
Why didn't I think of that?
Thanks