Hello all,

I have a problem with creatng a report. I've created a table that holds such fields as status (CP, IP, Clarification) owner name (Frank, Rob, etc.). I then went into my query view and proceeded to create totals for status, # of records, and status by owner name. For example, in one of my queries I included fields.. status (Criteria of CP), owner name (criteria of Frank) and a field total(*) -- In doing so My query calculates the number of records Frank has completed. I did this for each owner and even created queries to calculate how many records were CP IP and needed Clarification. What Im looking at here is about 10 queries with all 1 number each..a total. Now the queries work perfect and all I want to do is encompass these numbers onto one report. What is my best way to go about this? Create 10 seperate sub reports? I tried bringing in all the fields onto one report but it ran me an error. Any suggestions? Thank you so much for your help.

If each query produces a single row for each person, you can create another query that joins each of the queries to the main query on Owner. You can then use the new query as the recordsource for the report.