sorting calculated field access report

[vagues0ul]

i have a calculated field in access report and when i sort report on that field it gives me this error.

Operation is not supported for this type of object

the field is from a table where it is calculating average of 3 other fields.

 

[Gasman]

Calculate in the source and then sort on it?

 

[vagues0ul]

Calculate in the source and then sort on it?

dnd't got your point

 

[June7]

Is the calculation in textbox on report? Calculate in the report RecordSource query. Use that field for sorting.

Otherwise, use the expression as sort parameter in the report design, not the textbox.

 

[vagues0ul]

Is the calculation in textbox on report? Calculate in the report RecordSource query. Use that field for sorting.

Otherwise, use the expression as sort parameter in the report design, not the textbox.

am i doing it right ?

Private Sub Report_Load()
Report.OrderBy = "[termttl]*0.4 + [stmttl]*0.6 Desc"


End Sub

 

[June7]

I have never used VBA to set a report OrderBy property. Either set the property in design or use report Sorting & Grouping.

If you have any Sorting & Grouping setup, the OrderBy property will be ignored. Sorting & Grouping takes precedence.

I presume report is named something other than "Report". Correct syntax:

Me.OrderBy = "[termttl]*0.4 + [stmttl]*0.6 Desc"

 

[Pat Hartman]

Don't do this with code, modify the report itself. Open the report in design view and add a sort option using the sorting & grouping dialog. Reference the calculated field in the RecordSource.

 

[vagues0ul]

Don't do this with code, modify the report itself. Open the report in design view and add a sort option using the sorting & grouping dialog. Reference the calculated field in the RecordSource.

the error i posted is the result of same steps you are mentioning

 

[June7]

We are going in circles. Suggestions are proven methods. If you want to provide db for analysis, follow instructions at bottom of my post.