A simple question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 !!
 
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 !!
Click to expand...

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!
 
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.
 
Back
Top