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
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