You might try using the word DISTINCT in the SQL statement. That
should get you one record per match. Also, you have no criteria (WHERE
clause). I have modified the SQL statement (my modifications are in
CAPS - I made the rest of the statement lowercase to show my changes).
select DISTINCT customer, count(0)
from table1 WHERE (SOME CRITERIA)
group by customer
order by count(0) desc
HTH!
Alienwebmaster
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
