count

[klp via AccessMonster.com]

I have a report that I have been emailing help on with you guys. Everyone has
been such a great help. My report is a 12 month rolling report, which is
based off of a crosstab query. I need a field called count. This will count
what months have data in them. So for example:

Item Mth1 Mth2 Mth3 Mth4 Mth5 Mth6 Mth7 Mth8 Mth9 Mth10 Mth11
Cnt
12 2 0 0 0 0 3 3 6
2 0 6

The count being which months are > 0. Do I create this in my query or better
off in my report?

Thanks in advance

KimP

 

[Duane Hookom]

I would probably try perform the calculation in the query.