Access DB distinct count

[anziga]

I would like to count each distinct values from certain column in ACCESS DB. Let's say I have values like:


1
1
1
2
3
3
3
3
I need to get the number of each distinct values and show the value, something like:
1, 3
2, 1
3, 4
I tried using:

qry = "SELECT COUNT(*) FROM (SELECT DISTINCT description FROM expenses GROUP BY description)"

and some variations of this query, but e.g. this query just shows total number of distinct values. DB version is ACCESS 2k. Is there a way to do what I'm after?

[michaeljohnh]

If I understand correctly, you simply need to make a query with 2 columns (no editting of SQL required). In Access 2007 there is a totals button when in design view of a query. Press it and a new row called Total appears. Drag and drop the column youre trying to group and count into 2 separate columns. With the Total function, set the first column to Group By which is what it should default to and set the second one to Count.

[weekend00]

Michael describe it in design view.
I try to describe in SQL view since Anziga have CODE already:

qry = "SELECT COUNT(*), description FROM expenses GROUP BY description"

[anziga]

Sorry, I wasn't clear enough. I run this query from VB10, I'm not using actual ACCESS, just a database. I need to do a distinct count for one column only, and use the result elsewhere. This:

qry = "SELECT COUNT(*), description FROM expenses GROUP BY description"

did the trick, thank you very much!