Arthur Fuller
artful at rogers.com
Fri Jul 23 08:05:04 CDT 2004
I think that you have no choice but to bounce the derived field up to the master level of the report (that is, join the detail table to the master so you can grab this one field), and then do your grouping on that. Doing this will probably give you duplicate rows at the master level but you can get around that by grouping on the columns that duplicate. Try it as a query first, and then once you have it working, slam it back into the report. HTH, Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stephen Bond Sent: Friday, July 23, 2004 7:28 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Report Grouping on a derived query field Gustav, identical result as before :-< > > How do you specify it in the report's headings and groupings > > specification? You may need to write the original expression: > > > > =IIf(Month(startDate) < 7, Year(startDate), 1 + Year(startDate)) > > > > Is startdate included as i (not visible) textbox in the report? > > > > /gustav -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com