Help with Count

[GAKEN]

Hi all!

I have a table that has Order Number and an Account Number, I want to count all the account numbers. However there might be more then one order number with the same account number...

See example:

Table:

[Order Number] [Account Number]
12312                 1234
13231                 2342
14352                 1311
23423                 1313
11422                 1234

Output should be: 4

I want to count([account number]) and get 4, notice there are 5 rows, the 1st and last have the same account number.

How do I write this query?

Thanks,

Ken

 

[GAKEN]

Found the anwser I was looking for!

select count(distinct [account number]) from table