Is there a reason you can't use 3 separate queries? That would be straight forward in my view.
For a different approach, consider a table (anasttin with fields Product, InPlaceYearStart, InPlaceYearEnd, YearOfData.
And sample data
Code:
Product, InPlaceYearStart, InPlaceYearEnd, YearOfData
P1,yes,yes, 2015
p2,yes,yes,2015
p3,no,yes,2015
p4,yes,no, 2015
Query:
Code:
SELECT Anasttin.Product, Anasttin.InPlaceYearStart, Anasttin.InPlaceYearEnd
FROM Anasttin
WHERE (((Anasttin.InPlaceYearStart)="yes") AND ((Anasttin.InPlaceYearEnd)="yes"))
Union
SELECT Anasttin.Product, Anasttin.InPlaceYearStart, Anasttin.InPlaceYearEnd
FROM Anasttin
WHERE (((Anasttin.InPlaceYearStart)="yes") AND ((Anasttin.InPlaceYearEnd)="no"))
union
SELECT Anasttin.Product, Anasttin.InPlaceYearStart, Anasttin.InPlaceYearEnd
FROM Anasttin
WHERE (((Anasttin.InPlaceYearStart)="no") AND ((Anasttin.InPlaceYearEnd)="yes"))
Results:
Code:
Product |
InPlaceYearStart |
InPlaceYearEnd |
P1 |
yes |
yes |
p2 |
yes |
yes |
p3 |
no |
yes |
p4 |
yes |
no |
it might be a better set up, but you know your environment and readers don't.