A puzzler.
The first time I tried it I got:
"error - syntax is incorrect for the command vMiles_tot"
But when I copied the command to the clipboard, and pasted it into the variable define box again, it worked!!
Any ideas what this wierdness is?
David;
Are you sure that the data type was specified as TEXT for the variable? The only thing that
I can think of is that since the column is a REAL type, somehow the type was assumed to
be REAL which would not work with the text results from the IFNULL statement.
The other option is to actually use NULL in place of the " " and set the Blank When Zero
option for the field on. This will achieve the same result.
Best Regards,
Mike
