Mutliple Complex Queries - How to Combine into One Result/Report?

I

Inuchan

Thank you in advance for your assistance.

I have data that I must access on a weekly basis that involves a number of
criteria. To date, I have performed each query and then coalesced my findings
(by hand) into a table. Something tells me that this would be far easier with
better knowledge of the program.

I have three major data categories (Poor Performance rating, Location, and
Seniority) that are dependent upon sorting the Employees into three different
sections (Dismissed, Retained, and Reallocated). For each of the sections, I
must calculate the percentage based upon the main data categories (Horizontal
headings are Dismissed, Retained, and Reallocated; Vertical Headings are
Performance Rating, Location, and Seniority). For example, I need to
calculate the percentage of how many people who were dismissed had a poor
performance rating, how may retained had a poor performance rating, and how
many people who were reallocated had a poor performance rating. The rest of
the table must include percentages for all of the other categories calculated
in the same way.

Is there a way to construct a single query (or multiple queries if
necessary) that would capture this data and that could allow me to pull the
same data on a weekly basis? Is this something more for a report? Can the
report pull all of this data together and do it on a regular basis?

As you probably can tell, I'm still learning what I can about the program.
Thank you for your patience!
 
D

DeltaTech

Hi Inuchan

You can use Queries as tables to create a master Query

Create a new Select Query Name it qry_ReportQuery
Enter each query as if it were a table (excluding the percenrage
calculations of each query)
Test your qry_ReportQuery at this stage.
If you have all the other data displayed
Calculate the percentages in the qry_ReportQuery
If you try to calculate the percentages earlier you may get the Error
Message "TO COMPLEX"
Or your qry_ReportQuery may take an excessive amout of time to calculate.
Structure your weekly report based on qry_ReportQuery.

Have Fun

DeltaTech
 
I

Inuchan

Thank you so very much for your help! If you don't mind, I do have one
question: as for entering each query as if it were a table, can you offer
more advice on doing so? I am currently using Design View, but I'm at a
little bit of a loss as to how to enter in all of the queries that are needed.

THANK YOU!
 
D

DeltaTech

Hi Inuchan

You may want to read the help files on how to create tables and queries.

Open the new query in design view
"Click" on View Tables
"Click" on the Queries Tab
Enter the queries in the same way as you enter tables

Have Fun

DeltaTech
 
I

Inuchan

Thanks much, DeltaTech. I have been scouring the help files and feel like I'm
just about there. I appreciate your help.
 
Top