Text Box Criteria/Condition

[Beth Eadie]

I have a report that contains a graph and a key/legend at the bottom which
lists every location on the graph and the count of tests completed. Since
there are so many locations, the legend spills over onto the second page.
The end user wants it all to appear on the first page.

The suggestion of my end user was to break up the legend so that there are 2
columns of data.

The two text boxes I have on the report are [Location] and
=Count([Location]). Is there a way to make the location text box only
display locations beginning with A-K and then another that will display L-Z?
(And I'm assuming for the Count field, I would just need to Count that data).
I have tried a couple different things, but it is not working.

Is this even possible?

Thank you,
Beth

 

[Beth Eadie]

I was able to figure out how to display only locations with A-K as the
beginning letter (and L-Z in the other text box):

=IIf([Location] Like "[A-K]*",[Location],Null)

However, when I try to put Count in front to count the locations, it comes
up correctly for the buildings A-K, but displays 0 the rest of the way down.
Any idea why it displays 0 instead of nothing at all? I don't want to see
the 0 for the locations that are not being displayed.

Thank you,
Beth

 

[Beth Eadie]

I was able to figure out how to display only locations with A-K as the
beginning letter (and L-Z in the other text box):

=IIf([Location] Like "[A-K]*",[Location],Null)

However, when I try to put Count in front to count the locations, it comes
up correctly for the buildings A-K, but displays 0 the rest of the way down.
Any idea why it displays 0 instead of nothing at all? I don't want to see
the 0 for the locations that are not being displayed.

Thank you,
Beth