Sales Report By Month

There is a few ways to do this depending on your data structure.

1. If you haev many sales each month and need to add them up then you could use.

Sql = SELECT Sum(tblSales.SalesField) AS SumOfSalesField
FROM tblSales
WHERE (((tblSales.DateField) Between #6/1/2004# And #6/30/2004#));

or
2. If you have a total sales field then use

Sql = SELECT tblSales.SalesField
FROM tblSales
WHERE (((tblSales.DateField) Between #6/1/2004# And #6/30/2004#));

Do not use date as the name of the field either as this will cause problems with the sql.

Is this a MSSQL DB?
If so, I'd suggest one one query to return the data

select datepart(m,datefield), datepart(y,datefield), sum(salesfields) from tblSalesData group by datepart(y,datefield), datepart(m,datefield)

This will return the month, year and sales total for each month in one recordset.