Apply Sorting/Grouping Expression = Control Name

[Mike555]

In an Access report I have a textbox control in the Detail area named "txtFinalDate". The controlsource for this textbox is a very long IIF statement which evaluates the other fields of the detail record and displays a date. I'm trying to use this textbox in the Report's Sorting and Grouping but I'm unable to do so. If I copy the textbox's IIF logic into a new Sorting/Grouping expression I receive the error message "This calculation is too complex,etc,etc..." I've also tried to add a reference to the controlbox as follows...

Field/Expression
----------------
[Reports]![rptProdAnal].[Controls]![txtFinalDate]

Is it possible to use a report control as a Sorting/Grouping expression? If so, could someone please give me an example? Thanks.


--
Not until I became a Network Administrator did the error message "See your Network Administrator for assistance" become petrifying.

 

[MichaelRed]

Sorting / Grouping rely on (require) fields from the recordsource. Since you have the logic for the date, put in the recordsource as a calculated field and use the field (directly) both to populate the textbox and as the sorting grouping field




MichaelRed