count

  • Thread starter klp via AccessMonster.com
  • Start date

K

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top