PDA

Click to See Complete Forum and Search --> : Count

maru143
May 11th, 2006, 07:28 AM
I want to count the number of distinct rows in MS access.
Please help me.
Corpse
May 11th, 2006, 08:02 AM
Try this one (not tested!):

SELECT COUNT(DISTINCT column(s)) FROM table