Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 37
Topic: Conditional Max Value Posted: 08 Sep 2010 at 11:43am
Hi,
Is there an easy way to return the maximum value of an object, based on evaluating another object?
Specifically, as I print a check register, each line should have its check number in one field, and then next to it I need to reference the last check number of that specific check run.
All checks drafted on a particular run share the same date/time stamp, so I want to return the highest check number associated with a particular date/time stamp.
Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 37
Posted: 08 Sep 2010 at 12:07pm
Okay, so I just tried the running total, as that made sense to me, but oddly enough, when I select Maximum, I actually get the first one in the series (same as if I put Minimum). Not sure why that is, but I can't get it to work so I'm going to try the first method...
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
