[AccessD] Report Grouping on a derived query field

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




More information about the AccessD mailing list