I just started a website for collaboration and have built a simple database to track my memberships so far.  I have been able to use Access' built-in charting tool to create a chart based on a grouping query I've created (below).  But the graph shows signups per day, when I'd like to see a cumulative graph.  (See attached for illustration).  I do want to learn this--I really do--but is anyone willing to do this for me for a few bucks?  All I need is that graph. If so, please reply and create a profile on Coleegz.com.  The system allows for transactions (using PayPal) from within the site itself.

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]);

Select allOpen in new window