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