Search results

  1. M

    Display zero values in a crosstab query

    You can display zeros!!! Set up the value field as follows: Field--- VALUE: IIf(IsNull(Count([table]![field]))=True,0,Count([table]![field])) Table--- it will be blank since defined the table in "Field" Total--- this is important!!! it must be blank!!! because you defined the total in...
Top Bottom