Charlie Change it to (max(IntegerColumn)) from Table where IntegerColumn < .fIntegerColumn
Notice the change in the parentheses. Dawn -----Original Message----- From: Charles Parks [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 09, 2005 11:34 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Form Variable expression In a command file I could write select max(IntegerColumn) + into vValue + INDICATOR viValue + FROM Table + Where IntegerColumn < .vValue How woul I write that a form variable expression? I tried (max (IntegerColumn) from Table where IntegerColumn < .fIntegerColumn) and that doesn't seem to work.
