B
Bob Duffy
Guest
Hi there,
Got a problem getting my head round this one:
I have to generate a report that displays the results of the selections from 9 combo boxes. These are answers to equal opportunities questions on a job application form (e.g are you Male, Female, No answer!). They are stored in a "Job applicant" table.
I want to group the total responses over a time period specified by the user entering 2 date values. These date values are compared to the job closing date, stored in the "Job_Details" table.
So, for example, i want to see the total number of applicants who said they were male, the total number who said they were female, etc over the time period chosen.
I have 9 questions in this manner (e.g age, ethnic origin), all of which have to appear with totals on the same report.
Would it be easier to do 9 reports, one for each question?
Any help would be greatly appreciated on the SQL/report grouping.
Cheers
Got a problem getting my head round this one:
I have to generate a report that displays the results of the selections from 9 combo boxes. These are answers to equal opportunities questions on a job application form (e.g are you Male, Female, No answer!). They are stored in a "Job applicant" table.
I want to group the total responses over a time period specified by the user entering 2 date values. These date values are compared to the job closing date, stored in the "Job_Details" table.
So, for example, i want to see the total number of applicants who said they were male, the total number who said they were female, etc over the time period chosen.
I have 9 questions in this manner (e.g age, ethnic origin), all of which have to appear with totals on the same report.
Would it be easier to do 9 reports, one for each question?
Any help would be greatly appreciated on the SQL/report grouping.
Cheers