I have a report that I manually do now. its basically a query against an Access Database:

SELECT Count(Master.MasterID) AS Logs
FROM Master
WHERE (((Master.SubmitDate)<=#5/01/2010#) AND
(((Master.CompleteDate)>=#5/01/2010# Or (Master.CompleteDate) Is Null)));

it is basically showing me all open logs that are open on the first day of the month. In order to work this I have to change the date for each month and it can get tedious. I was hoping there was a way to do this using a crosstab or pivot table using a years worth of data(7/1 to 6/30). What do you think?

The problem here is that you want to count records that were 'Not completed' during each month versus opened during a month, corrrect?

your select statement for all records for 1 year would be something like:
(isnull({Master.CompleteDate}) or {Master.CompleteDate} in
dateserial(year(currentdate)-1,month(currentdate)-1,1) to dateserial(year(currentdate),month(currentdate),1-1)) and
{Master.SubmitDate}<=dateserial(year(currentdate),month(currentdate),1-1)