S skelley Registered User. Local time Today, 14:50 Joined Jul 11, 2000 Messages 69 Apr 4, 2001 #1 In an equipment list report, I have a detail section that has a "revision" field that has a value (even null) for each record in the detail section. I need to show the "largest" value of the "revision" field in the Report Header. How?
In an equipment list report, I have a detail section that has a "revision" field that has a value (even null) for each record in the detail section. I need to show the "largest" value of the "revision" field in the Report Header. How?
K KevinM Registered User. Local time Today, 14:50 Joined Jun 15, 2000 Messages 719 Apr 4, 2001 #2 Use the DMax function. In the control souce of a text box put.... =DMax("[Revision]","Table Name") HTH
Use the DMax function. In the control souce of a text box put.... =DMax("[Revision]","Table Name") HTH
