another Aggregate query question

[peace]

hello. This is my first post.

I am not a SQL person.

I know there is criteria solution for what I need but I cannot recall. I hope one of you nice friends will help me.

I have a field ( title Remarkmemo) in my table.
each record in that field is populated with a customer number (xxxxxx.xxxx).

I would like to call a criteria for the field, to count the total occurances of customer numbers, and give me the top 10 occurences.
e.g.:
xxxxxx.xxxx 15
yyyyyy.yyyy 21

etc..


I know it is possible without sql only using criteria, but I don't know how..

Please help.

many thanks...

 

[The_Doc_Man]

I'll show you how to find out.

I would just build the query to do the counts.

Then, in a second query based on the first one, I would order by the count field. Then click on the SQL view. After keyword SELECT, edit the SQL to include FIRST 10 (i.e. SELECT FIRST 10 x, y, z, .... FROM ...)

Now revert to design view and see what happens in the query grid.

That will answer your question.

Your aversion to SQL is unwarranted. SQL is your friend.

 

[peace]

still problem..

Doc. Thanks for the fast response.
I think I am as lost as it can get with SQL...

However:

I have the following (below) at the second query's SQL view, (same as the first count query).

SELECT [qry WM7 only numbers count].CountOfRemarkMemo
FROM [qry WM7 only numbers count];


I am using only one filed from the table ( I can add more fields later, once I get the trick).
Still no use..

I keep getting error messages. It seems like I don't even know how to manipulate SQL.

Do you have any sugesstions.

Thanks !