You can use SQL syntax in an RBase report variable, but it must be surrounded by Parentheses.
SET VAR vMax_wo# = (MAX(wo#)) IN ... SHARON LIMA <[EMAIL PROTECTED]> wrote: >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 > > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
