I am trying to create several queries so that I can provide a report to my manager that shows how certain fields are automatically updated. What I did was create several queries that are linked to a form and then create a master query that has the count of the number of "ID"'s in each query. There are six queries that I want to take the count of "ID"'s and put them into a report. I used the DCount function and that worked fine. Then I tried to initiate a "Group BY" and Access freezes. What could be wrong? Thanks.