Sum query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello

I have a table with phone numbers in them and the duration that they
called I have a diffeerent table for each day. Each table has about
4000 records in it. There is about 200 phone number and they aopear in
each table


I would like to run a query that sums the duration with relation to
the phone number.

What I want is one column with the phone numbers, and different
colomns for the call duration for each day against the phone number.

I got it to work with onetable but when I add more tables for the
different days the sum of the durations isn't correct .

Any ideas on how to achieve this

Many thanks
.

Relevant Pages

  • Query based on field in current record
    ... txtMiles.value = dsum ... and similar for duration. ... >How do I, on the form, show sums of the data from ... >i can make a query that, based on an inputted number it ...
    (microsoft.public.access.forms)
  • Please HELP...nervous wreck time calculation
    ... the days, hours, and minutes; in duration; between two time stamps. ... format SUM? ... those times by adding several sums, and only adding those sums if they ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How is actual duration calculated at the project summary level
    ... Sums the Scheduled Durations of the subtasks. ... Multiplies % Remaining * Summary Duration to compute Summary Remaining ... Project MVP ...
    (microsoft.public.project)
  • Re: Sum query
    ... Super Slueth wrote: ... I have a table with phone numbers in them and the duration that they ... called I have a diffeerent table for each day. ... I would like to run a query that sums the duration with relation to ...
    (microsoft.public.access.externaldata)
  • Re: complete through, how calculated on summary bar
    ... Sums the Scheduled Durations of the subtasks. ... Multiplies % Remaining * Summary Duration to compute Summary Remaining Duration ... Subtracks SRD from Summary Duration to compute effective Summary Actual Duration ...
    (microsoft.public.project)