Sort a Report by a text box bound to expression

  • Thread starter Thread starter TEAM Racing
  • Start date Start date
T

TEAM Racing

I have a text box bound to an expression that uses values
from a subreport, so I can't create a field in the query
to sort. 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.
 
You are wasting your time attempting to set any order in the report based on
a value from a control on a report. Sorting can only be done with
calculations from the report's record source. Are you sure you can't
calculate the value from your subreport in your main report record source?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sort a report by a text box (not field in query) 3
how do i put more IIf for one text box? 3
Average question? 3
Break table up into multiple tables by row count? 1
Access VBA Problem in Access 2007 - Help 1
using values from a simple listbox to create a SQL IN Statement 3
Filter help 1
#error on form expression. 3

Back
Top