Transfer Data to an Excel Spreadsheet

[enizag]

I have a problem which needs a sloution, I have a database of a phone bill which contains all calls made from 100 different branches, this is split down to if the call was local "L", national "N" and local rate "LR", obviously each branch makes a number of each type of call. In total there is nearlly 60,000 calls.
What I need to do is seperate all the branches, then count how many local calls each of them made, then output this to a spreadsheet.
The output I envisage would look like this (in the spreadsheet)

BRANCH | NUMBER OF CALLS |
001
002
.
.
.
etc

the branch number is pre-defined, so both these fields are contained within the data.

[NeoPa]

This question was posted in the Access Articles section by mistake.
I have moved it into the Access Forum section instead.

MODERATOR.

[NeoPa]

Please include the MetaData for your table. Here is an example of how to post table MetaData :
Table Name=tblStudent

Field; Type; IndexInfo
StudentID; AutoNumber; PK
Family; String; FK
Name; String
University; String; FK
Mark; Numeric
LastAttendance; Date/Time

This will make it easier to provide the help you require.

[enizag]

Sorry I was a little vague, here is further information about the problem.

Table Name = TblCallRecords
the fields I need to take out of the table above are:

ChargeGroup; String
Date; Date/Time
DistBand; String

ChargeGroup is individual branches approx 100
Date is the date of the call
DistBand is either "L", "LR", "N", "fm1", "fm2", "fm3", "fm4" - this is the main field as I need all the "L"s count how many per day per branch, so if ChargeGroup = Edinburgh count all the "L"s made per day, then output these results into Access as a new table, which in turn can be exported to Excel.
I would like to do this via VB in Access, by just clicking a button.
Cheers

[NeoPa]

You can start with a query as below. No-one's going to do your whole project for you, but we may be able to help you along the way if you make the effort to try yourself first. That way, we can fill in the gaps.

SELECT [ChargeGroup],[Date],Count([DistBand]) As Calls
FROM [TblCallRecords]
GROUP BY [ChargeGroup],[Date]