DMin and DMax Function Issue on Access Report

I'm having a simple problem (or at least I believe it to be), one that has stumped me. I have a simple text box in my Access Report, page header.

Dmin("ppID", "qry001")

This report is based on a query that is tied to a form. When the user selects dates and an Administrator the report is generated. This function works perfect when the report is only 1 page. But when an Administrator's report is 2 pages, the second page goes bonkers. An #Error occurs in the Text Box of the second page and any subsequent page.

Is anyone out there to show me the way.

Thanks.

re: DMin and DMax Function Issue on Access Report

Hi

Try puting square bracket around the fieldname e.g. Dmin("[ppID]", "qry001")

Access sometimes lets you get away with various 'errors' and then later springs surprises, so it may be that it lets you get away with Page 1 but gets strict for Page 2

S7