Sorting/Ranking Aggregate Expression in Control Source???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
BevC. said:
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.
Click to expand...

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.?
 
"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.





Rick Brandt said:
BevC. said:
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.
Click to expand...

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.?
Click to expand...
 
BevC. said:
"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.
Click to expand...

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?
 
BevC. said:
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?
Click to expand...


Depends.

See your other threads on the same subject for reponses.
 
Back
Top