By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,275 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

DMin and DMax Function Issue on Access Report

P: 1
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.
Jan 24 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 446
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
Jan 28 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.