sorting data

  • Thread starter Thread starter connie
  • Start date Start date
C

connie

I have a report designed in access 2000 which ranks
students and then should print the report sorted by the
student with the highest rank. The report has three
calculated text boxes listed below. The last field,
[TEXT31], adds TEXT24 + TEXT28 to come up with the
student's total ranking. I want to sort the report by
the [TEXT31] field but when I put that field name in
SORTING AND GROUPING and then print the report, it
doesn't recognize the [TEXT31] field as a valid field on
the report. The report prints perfectly, otherwise. I
just can't figure out how to sort it by that text field.
This field is not in the QUERY, just calculated on the
report. How can I solve this problem?

text field TEXT24
=[ranking_rpt_related]![text6]+[text5]

text field TEXT28
=IIf([hs?]=True,[GPA]*0.5,[GPA])

text field TEXT31
=[text24] + [text28]
 
First of all, find a naming convention and use it. Your control names do
nothing to help maintain or explain your report.
You can only sort/group by expressions from your report's record source. You
might be able to use an expression like:
=[Field1] + IIf([Field2]=True, [Field3]*.5,[Field3]*1.0)...
 
Back
Top