[RESOLVED] Select Count Distinct

[Alexandru_mbm]

Anyone can help me with this code ?!

        Dim cn As New OleDbConnection(Conexiune)
        Dim SQLResult As Object
        Dim SQL As New OleDbCommand
        cn.Open()
        SQL.Connection = cn
        SQL.CommandText = "SELECT COUNT(DISCTINCT(editura)) FROM lista_carti)"
        SQLResult = SQL.ExecuteScalar
        Me.lbl_nr_edituri.Text = SQLResult

        cn.Close()

I have this error: Syntax error in FROM clause.

Why this is not working with access databases !?

[techgnome]

You have one too many closing parenthesis....

it should be

"SELECT COUNT(DISCTINCT(editura)) FROM lista_carti"

-tg

[Alexandru_mbm]

Thanks alot techgnome...

Now i have this one: Undefined function 'DISTINCT' in expression.

[Alexandru_mbm]

I did it!

SQL.CommandText = "SELECT COUNT(*) FROM (SELECT DISTINCT editura FROM lista_carti)"

Thanks again for your big help!

[bigMeUp]

Its been years since I did Access, but isn't it DistinctCount? (One word).

In SQL Server 2000, the query would be written:
SQL.CommandText = "SELECT COUNT(DISTINCT editura) FROM lista_carti"

[bigMeUp]

Oh, you did it! I really have to read these eff**g posts before I tap keyboard, innit?

[Alexandru_mbm]

I did it bigMeUp!

I dont think is in one word... i did not find anywhere something like that!

Thanks anyway for your help!

[bigMeUp]

Excellent, Alexandru_mbm! As a matter of interest, does

SQL.CommandText = "SELECT COUNT(DISTINCT editura) FROM lista_carti"

work?