G Glen New member Local time Today, 20:21 Joined Jul 12, 2000 Messages 8 Jun 7, 2001 #1 I have a report with lots of figures (in columns) and lots of spaces where the figure is presumably zero or null. How can I get the report to put a zero in all these blank spaces ?
I have a report with lots of figures (in columns) and lots of spaces where the figure is presumably zero or null. How can I get the report to put a zero in all these blank spaces ?
P Pat Hartman Super Moderator Staff member Local time Today, 15:21 Joined Feb 19, 2002 Messages 46,982 Jun 7, 2001 #2 Use the Nz() function in the controlsource of any field with the problem - =Nz(YourField,0)
