It is not as simple as just adding fields to queries . . . especially if there is Grouping going on.
SQL code is picky . . . so it is easy to 'break' the SQL statement by making a change in mid-stream.
I thought I had posted all the queries for you - but I'm losing track!
Here are my queries. I attached a screenshot of the data that the UNION query returns. Tell me if the data shown in the screenshot looks correct to you.
1. QryPost_0-1-2_One_Inspection
Code:
SELECT [QryPost_0-1-2].PI_Post_Number, [QryPost_0-1-2].FSL
FROM [QryPost_0-1-2]
GROUP BY [QryPost_0-1-2].PI_Post_Number, [QryPost_0-1-2].FSL
HAVING (((Count([QryPost_0-1-2].FSL))<2));
2. QryPost_FSL3_Show
Code:
SELECT QryPost_FSL3_Before_Last_Two_Weeks.PI_Post_Number, QryPost_FSL3_Before_Last_Two_Weeks.FSL
FROM QryPost_FSL3_Before_Last_Two_Weeks
WHERE (((Exists (SELECT QryPost_FSL3_Within_Last_Two_Weeks.PI_Post_Number
FROM QryPost_FSL3_Within_Last_Two_Weeks
WHERE QryPost_FSL3_Within_Last_Two_Weeks.PI_Post_Number = QryPost_FSL3_Before_Last_Two_Weeks.PI_Post_Number) )=False));
3. QryPost_FSL_4
Code:
SELECT QryPost_FSL_Post_Date.PI_Post_Number, QryPost_FSL_Post_Date.FSL
FROM QryPost_FSL_Post_Date
GROUP BY QryPost_FSL_Post_Date.PI_Post_Number, QryPost_FSL_Post_Date.FSL
HAVING (((QryPost_FSL_Post_Date.FSL)=4));
4. QryPost_Union_2
Code:
SELECT [QryPost_0-1-2].PI_Post_Number, [QryPost_0-1-2].FSL
FROM [QryPost_0-1-2]
GROUP BY [QryPost_0-1-2].PI_Post_Number, [QryPost_0-1-2].FSL
HAVING (((Count([QryPost_0-1-2].FSL))<2))
UNION
SELECT QryPost_FSL3_Before_Last_Two_Weeks.PI_Post_Number, QryPost_FSL3_Before_Last_Two_Weeks.FSL
FROM QryPost_FSL3_Before_Last_Two_Weeks
WHERE (((Exists (SELECT QryPost_FSL3_Within_Last_Two_Weeks.PI_Post_Number
FROM QryPost_FSL3_Within_Last_Two_Weeks
WHERE QryPost_FSL3_Within_Last_Two_Weeks.PI_Post_Number = QryPost_FSL3_Before_Last_Two_Weeks.PI_Post_Number) )=False))
UNION SELECT QryPost_FSL_Post_Date.PI_Post_Number, QryPost_FSL_Post_Date.FSL
FROM QryPost_FSL_Post_Date
GROUP BY QryPost_FSL_Post_Date.PI_Post_Number, QryPost_FSL_Post_Date.FSL
HAVING (((QryPost_FSL_Post_Date.FSL)=4));