View Full Code Snippet

SELECT IIf(Len(Month([regDate]))=1,"0","") & Month([regDate]) & "-" & IIf(Len(Day([regDate]))=1,"0","") & Day([regDate]) AS RegistrationDate, Count(T_Members.regDate) AS CountOfregDate
FROM T_Members
GROUP BY IIf(Len(Month([regDate]))=1,"0","") & Month([regDate]) & "-" & IIf(Len(Day([regDate]))=1,"0","") & Day([regDate])
ORDER BY IIf(Len(Month([regDate]))=1,"0","") & Month([regDate]) & "-" & IIf(Len(Day([regDate]))=1,"0","") & Day([regDate]);