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
