SUM in a Query?

[AlfredNor]

How to I show a sum in a query based on two tables?

I have a field in the query for a customer's telephone number and a number for the number of minutes they use. There can be several separate entries under the same number and I want to sum them. How should I go about it? Im the query? In a report?

thanks

 

[Fuga]

click the summation button in the query builder. In the "total" row, choose sum.

Fuga.

 

[AlfredNor]

hmmm

I thought thats what I did.

I created a new field in the table called sumfield.

Then I went into the query builder and added it to the query as one of the columns. I chose "sum" in the sort section in that column.

But when I run the query, it doesnt sum the (total mins) each set of (customer numbers) has.

 

[sxu-mic]

try this:

field Phone Number
Group by

field Number of Minutes
Sum