Z
zero_fusion via AccessMonster.com
Hello everyone,
this is my first post here, and hopefully someone could help me out with my
newbie question:
I did a database for a survey that we did at work, its about jobs and how
many ppl would be interested in them.
Each job is a field (in the table [jobs]) and has 3 options (data) : I like
it, Not Sure, I dont like it.
Also there is another Field : Gender in the table [page V]... which is either
male or female.
So i needed to make a query that would show the number of males that chose
(for me) the number that chose (not sure) and same for (not for me) for each
job (lets take medical assistant as an example). and the same for females.
so i did 3 queries for each job (query for each option) and a 4th query to
join the 3 queries together .
here is an example :
But that would be hectic as i have 22 jobs and 22x4=88 queries !
So is there a way to put the 3 options (for me, not sure, not for me) in one
query and then group it by Gender just like the original query ?
Any help would be much appreciated,
thank you.
this is my first post here, and hopefully someone could help me out with my
newbie question:
I did a database for a survey that we did at work, its about jobs and how
many ppl would be interested in them.
Each job is a field (in the table [jobs]) and has 3 options (data) : I like
it, Not Sure, I dont like it.
Also there is another Field : Gender in the table [page V]... which is either
male or female.
So i needed to make a query that would show the number of males that chose
(for me) the number that chose (not sure) and same for (not for me) for each
job (lets take medical assistant as an example). and the same for females.
so i did 3 queries for each job (query for each option) and a 4th query to
join the 3 queries together .
here is an example :
Code:
SELECT [Page V].Gender, Count(jobs.[Medical Assistant]) AS [Not sure]
FROM jobs LEFT JOIN [Page V] ON jobs.ID=[Page V].ID
WHERE ((jobs.[Medical Assistant]) Like 'not sure')
GROUP BY [Page V].Gender;
But that would be hectic as i have 22 jobs and 22x4=88 queries !
So is there a way to put the 3 options (for me, not sure, not for me) in one
query and then group it by Gender just like the original query ?
Any help would be much appreciated,
thank you.