[AccessD] Report Grouping on a derived query field

Gustav Brock gustav at cactus.dk
Fri Jul 23 05:59:03 CDT 2004


Hi Stephen

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


> Access 2000 - 
> In a query which feeds a report I have a derived field.  It is derived directly from a date field in one of the contributing tables, thus:

>   FY:Iif(Month(startDate) < 7, Year(startDate), 1+Year(startDate))

> The query runs perfectly, and gives me values like 2003, 2004 etc in the FY field.

> I am using this derived field, FY, as a grouping level (the only grouping level) in the report.  When I run the report, it bombs off immediately with the error message "The expression is typed
> incorrectly, or is too complex to be evaluated  ..." and more stuff about simplifying the expression. When I remove the Grouping Level completely the report runs.  There is no code-behind-forms
> (there will be but I have removed it to attempt to solve this).

> Any Ideas?

> TIA
> Stephen Bond
> Otatara, New Zealand 




More information about the AccessD mailing list