List box - totals - count

[Steindi]

Hello all,

I have a database that holds info about phonecalls to and from our company.

I have several list boxes in the table and one of it is a list box with 3 values "We called him" "He called us" "Other"

In a report i would like to count how many times this month we called him and how many times he called us etc.

What would be the best way to to this?

Thank you,
Steindi

 

[Trevor G]

Welcome to the forum,

You want to look at using a DCount Function on your report with 3 different textbox, do you want them as a summary or per group if you are sorting and grouping?

 

[Steindi]

Hi, thank you for your reply.

My english is not quite my best feature, but i'll try...

I need to publish in a monthly report how many times we contacted each person and how many times that person contacted us.

I use gruping and i group each customer and at the bottom of the report i need a total summary.

Best regards,
Steindi

 

[Trevor G]

So to get this right you want to see the Company Name, How Many times you called them and then by each category, in the Report Footer or in the Group Footer?

 

[Steindi]

In the report I group each customer

I would like to see in the group footer how many times we called them and how many times the customer called us.

In the report footer I would like to see how many time our company called all the customers and how many times all of the customers called us.

Hope this explains what I'm talking about

Thanx for your patience...

Steindi

 

[Trevor G]

You would need to either create a query and place the query in the Report Footer or create unbound textbox in the Report Footer and use a DCount something like this

=DCount("[Company]","tblGroupings","[Called]='We Called Him'")

If you use the help F1 key and type in DCount you will get an explaination and sample also google DCount Access

 

[Explorer]

Hey Steindi,

I tackled this problem yesterday. I have never tried Trevor's method so I don't know about it. I am a beginner and don't know how lame this solution will look like but here it is:
1. Create a query on which your report will be based and include the field on which you will need to count; in this case the field that contains that information "we called him" or "he called us" etc.
2. Create a report based on this query and go ahead with creating the group header and group footer based on your grouping.
3. In the design view of the report, click on the text box and then click and drag in the group footer area to draw an unbound text box.
4. Click on the name box (to the left of the unbound box) to change the name according to your need, example "We called him".
5. Click on the unbound box again and open its property by clicking on Properties button on top right.
6. Click on the "All" tab and in the control source type this:
=Count(IIf([Called]="We Called Him",1))
7. Click on "Data" tab and choose "No" for the Running Sum.

This should work as long as you use the exact same words in the Count statement as you are trying to count on in the Called field.

For the report footer, repeat the same process and put the unbound box in the report footer. But in the end for the Data tab, choose "Over All" for Running Sum.

Repeat the process for putting as many counters as you want in group or report footer.

Let me know if it worked. Remember I am a beginner and I understand the pain.