Sorting/Ranking Aggregate Expression in Control Source???

[BevC.]

I would like to sort the results of the following expression in control
sources located in the detail footer in order to rank the results.

=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151])

Is it possible?

Thanks for your help.

BevC.

 

[Rick Brandt]

I would like to sort the results of the following expression in
control sources located in the detail footer in order to rank the
results.

=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151])

Is it possible?

Thanks for your help.

BevC.

Okay, first off that's not an "aggregate" expression as you originbally
described it. An aggregate expression contains Min(), Max(), Sum(), etc..

Second, what "footer" are you talking about since there is no such thing as
a "detail footer"?

Third, you cannot sort on expressions based on *controls* you need to sort
on expressions based on *fields*. What is contained in the ControlSources
of text52, text145, etc.?

 

[BevC.]

"sum(=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151]))"
is actually the expression in the control.

The footer is for the customer which falls directly under the detail.

All of the text boxes contain numbers.

I would like to sort the results of the following expression in
control sources located in the detail footer in order to rank the
results.

=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151])

Is it possible?

Thanks for your help.

BevC.

Okay, first off that's not an "aggregate" expression as you originbally
described it. An aggregate expression contains Min(), Max(), Sum(), etc..

Second, what "footer" are you talking about since there is no such thing as
a "detail footer"?

Third, you cannot sort on expressions based on *controls* you need to sort
on expressions based on *fields*. What is contained in the ControlSources
of text52, text145, etc.?

 

[Rick Brandt]

"sum(=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151]))"
is actually the expression in the control.

The footer is for the customer which falls directly under the detail.

All of the text boxes contain numbers.

Sorry, I don't think that's a valid expression. I don't think you can have
an equals sign inside of the Sum() parenthesis. In addition, you cannot
apply Sum() to controls you can only apply it to fields or expressions based
on fields. Where do the numbers in those TextBoxes come from?

 

[Marshall Barton]

I would like to sort the results of the following expression in control
sources located in the detail footer in order to rank the results.

=Nz([text52])+Nz([text145])+Nz([text146])+Nz([text147])+Nz([text148])+Nz([text149])+Nz([text150])+Nz([text151])

Is it possible?

Depends.

See your other threads on the same subject for reponses.