Hi all,
I’m hoping that someone will be able to help me. I have an Access 2010 db –
Table.MainInfo
PartID
Name
ContactData
Table.Projects
PartID
ProjectID
ProjectName
Right now, my queries are looking like – Name, Project
Leanne – ProjHappy
Leanne – ProjSad
Aaron – ProjSmiles
Linda – (Null)
Running in the report is easy, it all groups it. However, if I want to filter out those who have done ProjSad, it only filters the project. So it looks like:
Leanne – ProjHappy
Aaron – ProjSmiles
Linda – (Null)
How do I filter out those who have done the project totally? So basically, my end query would look like (filtering out all those who have done ProjSad):
Aaron – ProjSmiles
Linda – (Null)
I know the answer should be right in front of my brain, but I’ve been staring at this way too long. I’ve tried grouping – but since it’s text it’s not working, I’ve tried pivotcharts but it’s not as userfriendly as a report (and there are about 313 projects and 22K participants).
Thank you for your help!!