calculate

[lintow]

I have a problem calculating values

within my table I have 3 fields and 10 records

the first field is the SSN and the second is name and

third is a number value.

The table has duplicate SSN with number values

I want to calculate the value fields from the duplicate SSN to get a total on that SSN number

Example
00001111 Jones 50
00001111 Jones 150
I want to calculate the value field so it would be 200

Does anyone know how to do this

 

[GingerR]

Here's some query code for you:

SELECT TableName.SSN, TableName.PersonName, Sum(TableName.ValueField) AS Total
FROM TableName GROUP BY TableName.SSN, TableName.PersonName

you'll have to tweak with table/field names.

This is called a "Totals" query.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[SeeThru]

Or use report grouping!