Lin -
Be sure to "DOT" the variables that are to the right of the "=" sign in the variable definition. Your sample below should be: vSetCode = (IFNULL(.vAccountCode, ' ', (.vAccountCode+.vSetNo))) Sami From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald Sent: Friday, March 07, 2008 7:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Assigning a Variable in a Report Thank you Buddy. That didn't quite do it but this did: vSetCode = (IFNULL(vAccountCode, ' ', (vAccountCode+vSetNo))) I was trying to do the test on the wrong variable as well! Now it works!! Lin On Fri, 7 Mar 2008 19:43:11 -0500, "Walker, Buddy" <[EMAIL PROTECTED]> said: Lin If I'm understanding you right try this vSetNo = (IFNULL(.vAccountCode,' ',(.vAccountCode & set#))) I'm assuming VSetNo is TEXT and that vAccountCode is the value from your different table and set# in located in the report table. Buddy _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lin MacDonald Sent: Friday, March 07, 2008 6:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Assigning a Variable in a Report In a Report, I need to add the value from one column in a table to the value of a column in a different table and print that. If the column in the first table is NULL, I don't want anything to print, i.e. I don't want just the second column to print. Tried this, which didn't work: vSetNo = (IFNULL(.vAccountCode, ' ', set#)) How can I accomplish this? thanks, Lin
