Well to do this very easily in SQL use this syntax:

To find SUM of the field:

select sum(Table.Field2)

from Table

where Table.Field1 = 'A'

To find COUNT of the field:

select count(Table.Field2)

from Table

where Table.Field1 = 'A'

To find DISTINCT COUNT of the field:

select distinct count(Table.Field2)

from Table

where Table.Field1 = 'A'

Will this work.....or do you not have access to the Database..?

To find SUM of the field:

select sum(Table.Field2)

from Table

where Table.Field1 = 'A'

To find COUNT of the field:

select count(Table.Field2)

from Table

where Table.Field1 = 'A'

To find DISTINCT COUNT of the field:

select distinct count(Table.Field2)

from Table

where Table.Field1 = 'A'

Will this work.....or do you not have access to the Database..?