I want to make the default value '0' in a report from crosstab qry

  • Thread starter Thread starter AngelaM
  • Start date Start date
A

AngelaM

I am using a crosstab query as the source for writing a
report. The crosstab has counted the amount of people in
each category for each month, but where there were no
people in a certain category in a month, instead of a
blank space, I need the default value to be '0' so that
when I want to add totals for say june, july and august
in my report it will actually show a figure. At present
it is not adding the months I need together because some
of the fields are blank....Is there anything I can do
from within the report or do I need to go back to the
crosstab query, and if so what do I do there?
Any help would be appreciated,
Thanks
Angela
 
Perhaps you can use the Nz() function in the Report to
convert Null to zero.

Check Access VB Help on the Nz() function.

HTH
Van T. Dinh
MVP (Access)
 
Did Van's suggestion work
I have the same problem
How did you write the formual?----- AngelaM wrote: ----

I am using a crosstab query as the source for writing a
report. The crosstab has counted the amount of people in
each category for each month, but where there were no
people in a certain category in a month, instead of a
blank space, I need the default value to be '0' so that
when I want to add totals for say june, july and august
in my report it will actually show a figure. At present
it is not adding the months I need together because some
of the fields are blank....Is there anything I can do
from within the report or do I need to go back to the
crosstab query, and if so what do I do there
Any help would be appreciated
Thank
Angela
 
You can force a zero in the crosstab, use Nz() in the control source, or set
the format of the control in the report.
I prefer the first but it requires you to provide your sql to us.
 
Back
Top