hi, I want to count the no.of re

[shyamsundar]

hi,

I want to count the no.of records of a table, for unique field value where the field is not a primary key and the value appears more than one time, i tried with SQL grouping command that gives the result as below

1a -5
1b -3
1c -6

but the i want the result record count as 3 in the above case. I hope I am clear. pl. help.

Thanx Shyam
cwizshyam@yahoo.com