This might be a simple question - but I am self taught in access and sometimes I find myself missing the easiest information.

I am trying to perform a query in where I want to count the number of requisitions open for each department. But I want to exclude the month of November. The problem is that if I add the [date] field to tell the query not to include November - then the Group By and Count functions are no longer working because of the individual dates.

Is there a way to have this info in criteria without it including the final results in the query or without creating a separate query with the date perameters.

By the way I no nothing about SQL but I am not afraid to try to figure it out.

Thanks,
Kim

One way is to query a query. 1st query excludes the appropriate month; 2nd query queries that query and groups appropriately.

For the [Date] column in the query grid, select Where in the Total: cell and uncheck the Show: cell.

Thanks EMP - that worked perfectly!