Solved im stuck with queries

[TipsyWolf]

so i have 2 union queries.
1.

SELECT * from qryCountSiteActions
UNION Select * from qryCountSiteOverdue
UNION Select * from qryCountSiteStatusNew
Union Select * from qryCountSiteStatusInProgress
UNION Select * from qryCountSiteStatusCompleted
ORDER BY 1, 3;

2.

SELECT * from qryCountRiskInprogress
Union
select * from qryCountRiskCompleted
UNION Select * from qryCountRiskOverdue
ORDER BY 1, 3;

1. then they are used in continues form and its sql is

SELECT Tlocations.LocationID, Tlocations.Location, qryCrossTab_UnionActionCount.TotalActions, qryCrossTab_UnionActionCount.New, qryCrossTab_UnionActionCount.[In Progress], qryCrossTab_UnionActionCount.Completed, qryCrossTab_UnionActionCount.OverDue, Tlocations.LocationSort
FROM Tlocations LEFT JOIN qryCrossTab_UnionActionCount ON Tlocations.LocationID = qryCrossTab_UnionActionCount.LocationID
ORDER BY Tlocations.LocationSort;

but 2nd i can't figure it out how to put these statuses in there (highlighted)

so i need to find out how to make statuses shown in qryUnionRiskCount

not sure why in #1 it says qryCrosstab, but 2nd doesn't have Crosstab.. just qryUnionRiskCount

 

[TipsyWolf]

looks like a wrong query was attached in record source. sorry.