A simple question

[Nick Pedder]

I am working on a recruitment database and have a table containing all the details of returned application forms including equal opps data. What I want to do is run a query which tell me the breakdown of records for a specific vacancy. For example, how many people from each ethnic group applied for the post. I am sure this should be really easy, but I am new to access and seem to be a little stuck. Any help would be much appreciated !!

 

[John Vinson]

I am working on a recruitment database and have a table containing all the details of returned application forms including equal opps data. What I want to do is run a query which tell me the breakdown of records for a specific vacancy. For example, how many people from each ethnic group applied for the post. I am sure this should be really easy, but I am new to access and seem to be a little stuck. Any help would be much appreciated !!

We'd be glad to help if you would please describe the structure of
your tables. YOU know where "equal opps data" and so on are stored...
we don't.

A Totals query grouped by Ethnic would seem to be indicated, but not
knowing where the data might be, it's hard to give specific advice!

 

[Nick Pedder]

Thanks, ok - here goes -

Table called tblJobLog contains: Date Entered, Job Reference, Forename, Surname, Ethnic Origin, Sex, Age, Disabilities.

Not sure if this helps, but i'm trying to either enter a date or a job reference which will allow the query to provide me information such as SUR186 (this is a job reference and I assume i'll enter this as a parameter query ) British 10 Candidates, African Caribbean 5 Candidates, etc. I would like to be able to do the same with Age, Sex and Disabilities (the last two are yes/no, age info is held in six different groups.