How do I sort a report by a text box (not field in query)

  • Thread starter Thread starter TEAMRacing
  • Start date Start date
T

TEAMRacing

I have a text box based off of calcs from a subreport. I
am guessing that the "order by" property on the report is
the way to go, but can't seem to nail down the syntax.

I have tried the following in the "order by" property:
Text17
[Text17]
=[Text17]
[rptToolLifeATVs].Report!Text17
=[rptToolLifeATVs].Report!Text17
and so on

Please help.
 
I have a text box based off of calcs from a subreport. I
am guessing that the "order by" property on the report is
the way to go, but can't seem to nail down the syntax.
Click to expand...

You can't sort *by a textbox*, because the textbox isn't even filled
until the Detail section of the subreport is formatted.

Put the entire expression used in the calculation into the Order By
property, or (better) do the calculation as a field in the Report's
Query if at all possible.
 
Putting the expression in the "order by" property (and
turning it on) doesn't seem to work. I can't create a
field in the query, because I need to reference a text
box on a subreport to create the expression I want to
sort by. The end-product is a date if that complicates
anything. This is the expression '([Parts Left]/
[subform_Model-EAU subform].Form!Text12)'
 
Putting the expression in the "order by" property (and
turning it on) doesn't seem to work. I can't create a
field in the query, because I need to reference a text
box on a subreport to create the expression I want to
sort by. The end-product is a date if that complicates
anything. This is the expression '([Parts Left]/
[subform_Model-EAU subform].Form!Text12)'
Click to expand...

Hrm. I really don't KNOW how to do this, and don't even know if it's
possible! The fact that it's a date won't make any difference, dates
sort just fine, but it sounds like you need to sort the records on the
form based on a criterion which does not yet exist.
 
Back
Top