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.

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

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