Set EQNull on before trying the report. gary
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Geoffrey Wheeler Sent: Wednesday, October 28, 2009 10:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Setting Report VAR =NULL I'm having trouble getting a report variable to be NULL. I want 3 report fields to be blank if there is a NULL value. The first field comes from the table, the others are calculated from the first. The first field comes out blank with a NULL from the table. The NULL format is blank for all the fields. I tried to set a test variable = first field variable (that is NULL) but the test variable's field came out 0. Here's a logic function that I'm trying to use: (IFNULL(vQuantity,vQuantity,vQuantity/12)) I've tried several values for arg2 without being able to obtain a NULL result. 1 gives 1 ; this proves that the logic works and the problem is to get a null result '' gives 0 ' ' or (CVAL('NULL')) gives an error, 1st & last 2 args of IFNULL must be the same type NULL and 'NULL' give 0. ,, or , , give error: a comma cannot follow a comma. Geoffrey in Thailand
