Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro Max of another macro column

Status
Not open for further replies.

Redhead77

Technical User
Apr 28, 2005
3
US
I need a macro to get the maximum value of another macro in my report. Have tried a macro that gives me the sum of another macro field, need one that is similar to that to get the max. Any ideas?
 
I would try modifying the sum macro to include an "IF condition THEN action [ELSE Alternative_Action]", so that when you are stepping through the records if the value of the next macro derived field is greater than the current value, set the new derived field to the greater value.

Just a thought.

David L. Black Consulting
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top