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

[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!

 

[Ron]

I apologize for not responding sooner. Many of us have been very busy. Let
us respond inline
--
Ron

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.

What information is in your employee data tables? Do You have a field in
your employee data where you show an employee is Dismissed and/or
Reallocated? Do you have a field for Performance, Location, and Seniority?

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?

Yes you can get a query to pull this info and then you can generate a report
which will show it. First I need to see how your data is constructed.

As you probably can tell, I'm still learning what I can about the program.

Don't worry about what you don't know. . . .Let's rise your knowledge

Ron