Oct 29, 2007 #1 dstalls Programmer Joined Sep 27, 2007 Messages 18 Location US I would like to select the lowest value from related fields in two different tables. I can get the lowest value from each field by using Minimum, but how can I get Crystal to evaluate both fields and determine which is lowest? Any input? Thanks- Derik
I would like to select the lowest value from related fields in two different tables. I can get the lowest value from each field by using Minimum, but how can I get Crystal to evaluate both fields and determine which is lowest? Any input? Thanks- Derik
Oct 29, 2007 1 #2 lbass Technical User Joined Feb 9, 2002 Messages 32,818 Location US Try: minimum([{table1.field1},{table2.field1}]) -LB Upvote 0 Downvote