max_wo# = (max wo#) from worders where job# = job# and lot = .xlot
Troy ===== Original Message from [EMAIL PROTECTED] at 11/20/01 12:06 pm >Thanks for your help. > >I need to be able define a lookup variable in a report which >will be the MAX value which meets the specified condition. > >max_wo# = wo# in worders where job# = job# and lot = .xlot > >There will be several records in the WORDERS table that meet >the WHERE condition. I want max_wo# to be the LARGEST wo# >to meet the where condition. >I tried a few things but kept getting syntax error messages. > >Is this possible? >If so, could someone please provide me with the syntax. >Is this a DUH question? > >Sharon Lima
