[AccessD] Intermittent Errors on Access Report

All, 

I recently ran into a very strange intermittent error that has me puzzled.

We have a small (2 page) Access 2007 report that is automatically generated every night.

Most of the time, the report is generated perfectly.  However, occasionally errors are generated.

When this occurs, it always happens when the first detail line of page 2 is being generated.

Page 1 is generated perfectly (Page header, detail lines, page footer).
On page 2, the Page Header, Page Footer, and Report Footer are all correct.

However, all four fields in the first detail line show “#Error” and none of the remaining detail lines are shown for page 2.

I have dug into the report and cannot see anything strange.  Because this problem only occurs intermittently, I am not sure how to track it down.

Has anyone else ever seen something like this occur on an Access report?

Thanks,
Brad