David, Larry, Razzak, I tried all of your suggestions and still cannot make this work. It's starting to look like d�j� vu all over again... Gotta be simple, no doubt. Thanks for all your suggestions.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David M. Blocker Sent: Monday, December 27, 2004 8:13 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Form Expression Claudine My guess is that you must do this: vAdjMileage2 = (.vAdjMileage+10) rate IN d_rates WHERE client = .vclient AND carrier = 99 AND truck_type = .vtrucktype AND category BETWEEN .vadjmileage AND .vadjmileage2 David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Claudine Robbins" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, December 27, 2004 8:29 PM Subject: [RBG7-L] - Form Expression I am having a problem with a form expression. If I do the following at the R prompt, everything works R>SET V VCLIENT = 261 R>SET V VTRUCKTYPE = 29 R>SET V VADJMILEAGE = 300 R>SET V VRATE = rate FROM d_rates WHERE client = .vclient AND carrier = 99 AND truck_type = .vtrucktype AND category BETWEEN .vadjmileage AND .vadjmileage + 10 R>SHO V VRATE 443.27 But if I write the following expression in my form to define VBENCHRATE rate IN d_rates WHERE client = .vclient AND carrier = 99 AND truck_type = .vtrucktype AND category BETWEEN .vadjmileage AND .vadjmileage + 10 I cannot save the expression... All my variables are defined in globalvars.rmd and run upon entering the db. Can anyone readily see what I cannot?
