Access SQL string

[Cassio]

How can I count the total number of rows without repeating the equal rows of a certain column?

 

SELECT COUNT( DISTINCT field) FROM table

 

I guess it works on Interbase, but not on access.

 

Any ideas?

 

Thanks!

[philprice]

use GROUP BY at the end, peace.

[Cassio]

But the group by won't return the table total number of rows. It will return the number of rows for each repeated value.

[Robby]

If all you want is a total count...

 

"SELECT count(*) as totCount FROM Table"

[Cassio]

I want the total count without the repeated values, it would be like this:

 

SELECT COUNT(SELECT DISTINCT Field1 FROM Table) FROM Table

 

It would count how many distinct values are on a certain field.