Hi all, I created a view in which some fields are giving me a null value. For example, if customernumber 100 isn't found, customername is ".NULL." instead of giving me an actual customer's name from my Customers table.
This is correct, but is there a way to have this field show me blanks instead of ".NULL."? The reason I ask is for printing the report. I'd rather the report be blank in these cases instead of printing .NULL. Thanks, John "The difference between a successful person and others is not a lack of strength, not a lack of knowledge, but lack of will." - Vince Lombardi * All mail scanned by Norton AntiVirus. No AV software on your computer? Remove me from your address book, please. * Please respect my privacy. Do not forward my address to anyone else or include me in emails sent to multiple recipients. Use BCC. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
