Hello,Please how do I format data with Nz functions in my SQL statement.
B brodaman Registered User. Local time Today, 17:42 Joined Nov 23, 2015 Messages 25 Dec 22, 2015 #1 Hello,Please how do I format data with Nz functions in my SQL statement.
S sneuberg AWF VIP Local time Today, 08:42 Joined Oct 17, 2014 Messages 3,506 Dec 22, 2015 #2 Nz doesn't format. It just substitutes something in place of a null. What do you want to format and how should it end up.
Nz doesn't format. It just substitutes something in place of a null. What do you want to format and how should it end up.
B brodaman Registered User. Local time Today, 17:42 Joined Nov 23, 2015 Messages 25 Dec 22, 2015 #3 I want to format a field containing currency e.g #320,000:00 but I cannot rather it comes out in #320000.bcos of Nz function I use to make null value=0.
I want to format a field containing currency e.g #320,000:00 but I cannot rather it comes out in #320000.bcos of Nz function I use to make null value=0.
S sneuberg AWF VIP Local time Today, 08:42 Joined Oct 17, 2014 Messages 3,506 Dec 22, 2015 #4 Can you apply the Nz before the format, i.e., Format(Nz( ......