Phone Totals

[Guest]

I have a table that has 5 fields, “Extension, Date, Time, Duration, and
Phone#â€. What I want to do is create a report the shows a extension, date
and if I called phone# 222-2222 6 times, I want it to show a subtotal of 6
and a subtotal for the total time I talked to that #. I have about 40-45
Phones# so a subtotal for each Extension, then a total time on the phone for
all extensions.

Thanks

 

[Allen Browne]

Use a Totals query:

1. Create a query.

2. In query design, depress the Total button on the toolbar.
Access adds a Total row to the grid.

3. Drag the Phone# field into the grid.
Accept Group By in the Total row under this field.

4. Drag Phone# into the grid again.
Choose Count in the Total row this time.

5.Drag Duration into th grid.
Choose Sum in the total row.

The query shows you each phone number, the count of times to that number,
and the sum of duration to that number.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

"open a adobe file from a command button"
message
news:[email protected]...