Report to compare data

[Guest]

Can anyone help me design a report to compare data from 2 queries please. I
need one column to list the number of staff per department and another to
show how many of them have attended training courses.

Manythanks

 

[Duane Hookom]

Apparently part of the challenge to us is guessing query and field names as
well as imagining what your records might look like....

 

[Guest]

That would be a challenge!!!

No - it's quite simple - things like:

Total No of Staff. Staff attended
training

Finance 10 5
IT 9 4
School Nursing 20 13
Health Visitors 30 17

And of course to calculate totals and percentages which isn't a problem.

The data must come from 2 queries and I know that I could use DLookUp for
each entry but there's so many departments I'm sure there must be an easier
way.
Thanks

 

[Duane Hookom]

It may be simple but we would still need to guess the query and field names
of your source queries. Are they both grouped by a department field? Pretend
we know nothing about your data (which is true).

 

[Guest]

At present I have a query called CountTotalStaff and the field I need to
report on is CountOfStaffRef. It's grouped by Department. The other one is
CountStaffTrained and the field has the same name, although I would change it
once I got a vague idea of what I'm doing. This is also grouped by
department.

It gets quite complicated as there are many departments and then it would be
sorted by Directorate and Manager etc. I just need to get the basics then I
can sort the other bits out. That's not a problem.

I know how to do reports with sub reports, but in this instance I need to
list the information from one query (total staff) and then list the number of
staff trained alongside for each department, then calculate the percentage of
staff that have been trained in the period.

Thanks

 

[John Spencer]

Dear Lin T,
What Duane is trying to get you to do is post the SQL text of the two
queries. It would also help if you posted something about the fields.

Please copy and post the SQL of your queries.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message