Gustav Brock
gustav at cactus.dk
Fri Jul 23 06:55:48 CDT 2004
Hi Stephen Then, as neither Andy's suggestion did make a difference, something else must be going on. You may need to group on more fields - you can try that out in the query itself. /gustav > 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