Maybe this will help?
1. create a table with just the months as numbers (1-12)
2. create a new query using your existing query summarizing the
order totals by month and the table in step 1 ... but do not join
the two tables. Now in this new query return these two fields:
month from the table in step 1,
sum(order totals) from your existing query
with the following Where criteria:
month of existing query <= month from table in step 1.
The sample I ran has the following sql in access
SELECT month.month, Sum(OrderByMonth.Total) AS AccTotal
FROM [month], OrderByMonth
WHERE (((OrderByMonth.M)<=[month]))
GROUP BY month.month;
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> 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/
