Totals in a report

[Guest]

Hi
I have a table listing calls agent take with categories.
Table: CallLogUK
Fields I would like totalled are "WrapCode". I have a query but it shows
each wrap code several times instead of once followed by the number of times
it is used. can someone please assist me?
Thanks

 

[Larry Linson]

"SJL" wrote

I have a table listing calls agent take with categories.
Table: CallLogUK
Fields I would like totalled are "WrapCode". I have a
query but it shows each wrap code several times
instead of once followed by the number of times
it is used. can someone please assist me?

Did you create a Query, then in design view in Query Builder, select View |
Totals from the menu, then add appropriate GroupBy, Count, etc. options?
Without any idea of what you included or did not include in your Query, we
would have a very difficult time debugging it.

Larry Linson
Microsoft Access MVP

 

[Guest]

Hi Larry

Thanks for your help. I gave it a bit of thought and what you ask above I did.

SJL

 

[Guest]

Hi Larry,

Thanks for responding....

I have a query set up that gives me the names, addresses etc and the paid or
not paid column. I am not sure what option I should choose in the totals
field...count?
I just want a one liner that says this is how many members total and then
how many are yes to paid and how many are no to paid.

does that make more sense?