Sort by textbox result

[bill1one]

I have a text box called txtTotal. It is an unbound object that equals the total of 8 different fields ([Week 1] + [week 2] + [week 3] + etc.) I'd like to sort my report by txtTotal, but when I change the property box to sort by that object, I get no result. Is there a different way to do this?

 

[Blorf]

Try in your sort criteria putting =([Week 1] + [week 2] + [week 3])

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[bill1one]

I am using the Order By property and it doesn't work. Is there perhaps a VB code?

 

[dhookom]

If the Week fields are in your report's record source, open the sorting and grouping dialog and add

  =([Week 1] + [week 2] + [week 3] + etc.)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]