Counting in a Report 1

[jdwm2310]

Hi,

I have a problem...I have a report on the reporter footer I am inserting a total box: where the manager can see total of tickets, total numbers of pending etc. I got the count for the total number of tickets but the total numbers for pending is driving me crazy since it is combo box. I want to show the estimate for each selection within that combo box. Any suggestion will be greatly appreciated..thanks

 

[BanditWk]

What I've done with this (because we ALL just LOVE those Managers and Executives that want to make our lives a living hell) is that I would create a Text Field for each value they're wanting to get a total for and put the following code in it:

For the Pending Total Box:
=Sum(IIF([FieldName]="Pending",1,0))

For the Completed Total Box:
=Sum(IIF([FieldName]="Completed",1,0))

And so forth and so on

HTH Roy McCafferty
aka BanditWk

Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

"No need to send gifts, just send a smile."

 

[jdwm2310]

Roy,

You are a lifesaver...those managers are down my neck but thank goodness you guys are always there to lend a helping hand....HERE’S A BRIGHT SHINING STAR FOR YOU!!!!!!!!!!!

 

[Guest_imported]

I am creating a Production Form where the employees enter their daily totals. From that form I need to generate a report that totals the averages of each employee for that certain month. Can someone tell me how to do this?

JTB