Max of one of several Report fields

[Tom Green]

I have a report with 4 columns. I'd like to enter a fifth column that simply
displays the max of one of the four at left. Silly, but this is what the
client wants. Max returns the Max of a single field, MAXA doesn't apply. I
suspect my syntax is not parsing:

=MAX(([Field1],[Field2],[Field3],[Field4]))

Domain aggregate functions also seem to apply only to a single field in the
dataset as opposed to disambiguating which is greatest. Any ideas?

Thanks in advance

 

[Marshall Barton]

I have a report with 4 columns. I'd like to enter a fifth column that simply
displays the max of one of the four at left. Silly, but this is what the
client wants. Max returns the Max of a single field, MAXA doesn't apply. I
suspect my syntax is not parsing:

=MAX(([Field1],[Field2],[Field3],[Field4]))

Domain aggregate functions also seem to apply only to a single field in the
dataset as opposed to disambiguating which is greatest.

There is no built in function to find the max of a list of
values. Here's a little function I use for this kind of
thing:

Public Function MaxOfList(ParamArray vValues() As Variant)
As Variant
Dim vX As Variant

MaxOfList = vValues(0)
For Each vX In vValues
If vX > MaxOfList Then MaxOfList = vX
Next vX

End Function

 

[Tom Green]

Very creative. From what I understand it's not possible to assign the
ControlSource property to a report control at runtime from code (is there a
way?), so how can I implement this?

Thanks!

I have a report with 4 columns. I'd like to enter a fifth column that simply
displays the max of one of the four at left. Silly, but this is what the
client wants. Max returns the Max of a single field, MAXA doesn't apply. I
suspect my syntax is not parsing:

=MAX(([Field1],[Field2],[Field3],[Field4]))

Domain aggregate functions also seem to apply only to a single field in the
dataset as opposed to disambiguating which is greatest.

There is no built in function to find the max of a list of
values. Here's a little function I use for this kind of
thing:

Public Function MaxOfList(ParamArray vValues() As Variant)
As Variant
Dim vX As Variant

MaxOfList = vValues(0)
For Each vX In vValues
If vX > MaxOfList Then MaxOfList = vX
Next vX

End Function

 

[Marshall Barton]

Very creative. From what I understand it's not possible to assign the
ControlSource property to a report control at runtime from code (is there a
way?), so how can I implement this?

I don't see where runtime has anything to do with your
question. Just set the text box's Control Source in design
view:
=MaxOfList([Field1],[Field2],[Field3],[Field4])
--
Marsh
MVP [MS Access]

I have a report with 4 columns. I'd like to enter a fifth column that simply
displays the max of one of the four at left. Silly, but this is what the
client wants. Max returns the Max of a single field, MAXA doesn't apply. I
suspect my syntax is not parsing:

=MAX(([Field1],[Field2],[Field3],[Field4]))

Domain aggregate functions also seem to apply only to a single field in the
dataset as opposed to disambiguating which is greatest.

There is no built in function to find the max of a list of
values. Here's a little function I use for this kind of
thing:

Public Function MaxOfList(ParamArray vValues() As Variant)
As Variant
Dim vX As Variant

MaxOfList = vValues(0)
For Each vX In vValues
If vX > MaxOfList Then MaxOfList = vX
Next vX

End Function