I am trying to find out how to run a query that will look at one table(tblSchedule) and create queries for each day of the week. I am trying to learn access and the teacher and book we have to use suck! Then I have to create a query that will count the number of jobs on each day of the week. When I asked the teacher he said look it up in the textbook(not there) or use the net! Kind of sucks that this is a college class! Any help would be greatly appreciated. We have not learned anything about SQL and the teacher says look in another class(advanced Micro Apps) for help with access. I am in the third week of that class and we are only covering word so far.