I have a simple address book sqlite3 table named ADDRESSBK. It has the basic fields Name, address, phone, etc. I also have a field named "Publish" which can be (Y)es or (N)o. Just Y or N. When making a report if this field is "N" how would I go about hiding some other fields on that same line like Phone or Address? Would I use a script, and if so what is the correct format. I tried something like this but it doesn't work:
If [SQLQuery1."PUBLISH"] = 'Y' then [SQLQuery1."ADDRESS"] := '';
Thanks,
Greg