Access 2002: Selecting necessary data from several tables

[D.M]

I have table "statistic".

I have to make next representation:



Network group
Number of calls
Number of impulse
Impulse cost
Profit




1. Network group: is first two numbers from 8 numbers from seventh field in
table called "TELEPHONE NUMBER".How to do this ?

2. Number of Calls: Total number from "START_TIME"; This I know;

3. Number of impulse:

END_TIME-START_TIME / impulse_lenght*Impulse_cost; How to do this ???



4. Impulse cost is parametar (manual enter)

5. Profit according to network group. How to do this ???



Thanks, I hope You can help me, please contact me if you need more
informations.