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
