A ALAN Registered User. Local time Today, 22:21 Joined Jul 12, 2000 Messages 23 Apr 16, 2002 #1 I use Crosstab query in a report, how to automatically change the blank spaces in the report to zero?
I use Crosstab query in a report, how to automatically change the blank spaces in the report to zero?
A ALAN Registered User. Local time Today, 22:21 Joined Jul 12, 2000 Messages 23 Apr 17, 2002 #3 I got error message, can u give other suggestions please.
G GinaO New member Local time Today, 22:21 Joined Jun 27, 2002 Messages 6 Jul 7, 2002 #4 Hi Alan, did u find the answer to this? i have the very same problem. Thanks, Gina.
Fizzio Chief Torturer Local time Today, 22:21 Joined Feb 21, 2002 Messages 1,885 Jul 8, 2002 #5 Rich is correct but you need to preceed it with = ie = Nz([YourField],0)
