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]
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]