I hope this is an easy one. I'm writing a query that returns account numbers, the account allotment for the fiscal year, the amount they spent in two different categories and their account balance. I'm only getting data returned for those accounts that actually spent something. For those that didn't I'm getting a blank in the two spending categories and balance fields. I want "$0.00" returned in the two categories and the balance fields. How do I do it. I tried Iff(Null,"$0.00"), but that didn't work.
I'd appreciate any help anyone can give me.
Thanks!
Tony
I'd appreciate any help anyone can give me.
Thanks!
Tony