Report based on a qry crosstab

  • Thread starter Thread starter Pedro
  • Start date Start date
P

Pedro

Hi everyone
How can i, on a report, create a field that counts me all
months, with values > 0. I have to do it on a report and
don't know how? Maybe this an easy one for you but not for
me.
That reports shows me a name, another text filed and all
12 months of the year. I have to know how many months on
that detail section has a value > 0 (zero) or not null.
Any ideas please?
Tks in advance
Pedro
 
=(Nz([Jan],0)<>0) + (Nz([Feb],0)<>0) + (Nz([Mar],0)<>0)...+ (Nz([Dec],0)<>0)
 
You must log in or register to reply here.

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

Grouping a Report made with a cross tab qry 11
Report made of a query cross table 5
Report over Crosstab qry 1
Subtract on a report based on QRY cross table 14
Reports with Groupings 1
weird sum on report 2
Create a balance on every line of a report 16
Reports with dates 2

Back
Top