Need to modify TRANSFORMATION query

[skydivetom]

Hello Experts:

I'm trying to streamline my queries in order to mitigate the need for a "helper" query. Please see below two SQL statements (Design View 1 and Design View 2). Both of these queries execute successfully.
- The 1st query is currently used as a "helper" query for input to another query (not listed here).


- The 2nd query is a transformation query which did NOT use a helper query.

SQL ("Design View 1"):

SELECT [00_tbl_SourceFields].FieldnameStandardized, [00_tbl_SourceFields].FieldStatusFromXLS, Count([00_tbl_SourceFields].FieldnameStandardized) AS [Count]
FROM 00_tbl_SourceFields
GROUP BY [00_tbl_SourceFields].FieldnameStandardized, [00_tbl_SourceFields].FieldStatusFromXLS
HAVING ((([00_tbl_SourceFields].FieldStatusFromXLS)<>"N/A"));

SQL ("Design View 2"):

TRANSFORM First(Step1.Expr1) AS FirstOfExpr1
SELECT Step1.FieldnameCurrent
FROM (SELECT [qry10_AlikeFields_Before_Input].FieldnameCurrent, [qry10_AlikeFields_Before_Input].Source, "●" AS Expr1 FROM qry10_AlikeFields_Before_Input GROUP BY [qry10_AlikeFields_Before_Input].FieldnameCurrent, [qry10_AlikeFields_Before_Input].Source, "x")  AS Step1
GROUP BY Step1.FieldnameCurrent
ORDER BY Step1.FieldnameCurrent
PIVOT Step1.Source;

Based on the design view of the TRANSFORMATION (2nd) query, I don't see all required fields that I'd like to add.

My question: Ultimately, I need to have the filter (HAVING clause) = "HAVING ((([00_tbl_SourceFields].FieldStatusFromXLS)<>"N/A"))" in my transformation query. How do I integrate the HAVING clause into the 2nd query?

Thank you,
EEH

P.S. Please see attached two JPGs which provide the *Design View* for both queries.