creating totals in a report...HELP

[JennW]

I have a table where I need to create totals of data that has been entered in a field.

There are 3 fields. Name, Type, and Number

Name Type Number
Jones Regular 12
Smith Regular 1
Jones Regular 3
Jones Regular2 5
Smith Regular2 2
Smith Regular2 5


I need to be able to have a report show only one Jones and the "type", and a total of the numbers that were associated with the name.

I have tried different types of querys and I sure could use some help.

There are over 100 names with 3 different "types" and about 9000 records with various Numbers.

Any suggestions?

thanks!

JennW

 

[JPMontreal]

Create a query like that:

SELECT MyTable.Name, MyTable.Type, Sum(MyTable.Number) AS TotalNumber
FROM MyTable
GROUP BY MyTable.Name, MyTable.Type;


Jean-Paul
Montreal
mtljp2@sympatico.ca

 

[JennW]

thank you Jean-Paul, but I tried this and it didnt work.

Any other suggestions are appreciated!

thanks!

JennW