Finding percentages

[Guest]

How would i find the percentage of trainees employed from the total number of
trainees using queries??

Can anyone help me on this matter??

 

[Jeff Boyce]

We aren't there. We don't know what data you have, nor how you have it
organized (into tables).

Queries are based on tables, so we need to know your table structure to
offer specific advice.

Generally, I'll assume you have at least: trainee, Employed? fields.

I assume that you are not trying to total the "number of trainees using
queries", but the number of trainees.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

How would i find the percentage of trainees employed from the total number of
trainees using queries??

Can anyone help me on this matter??

Create an appropriate Query based on the structure of your tables.

if you would like us to help you do so, please tell us something about the
structure of your tables and where the trainee and employment information is
stored. We can't see it from here!


John W. Vinson [MVP]

 

[Guest]

For example, I have 160 trainees, 35 employed in town, 12 employed out of
town, and the rest un-employed. The trainees info is in a table called
personal info with ClientNum being the PK (autonumber), and I also have a
table called employment which has the trainees employment status. The
employment table has many fields including EmpID(PK), ClientNum, EmpStatus
(Which includes a drop-down list of 4 options: employed, unemployed,
self-employed, employed out of town). I have the clientNum field linking the
two tables together (one-to-many relationship).