[AccessD] Crosstab Query - Additional Parameter

I'm suprised that you aren't getting an error 
"Access does not recognize " as a valid field name".

There are usually problems in referencing controls on forms in crosstab queries.

-- 
Stuart

On 11 Sep 2009 at 12:44, RANDALL R ANTHONY wrote:

> Here's the SQL:
>  
> TRANSFORM Count(TAB1.COMP_NUM) AS [The Value]
> SELECT Trim([TAB2].[LOB_DESC]) & " (" & Trim([TAB2].[LOB]) & ")" AS NETWORK, Count(TAB1.COMP_NUM) AS Total
> FROM (TAB2 INNER JOIN (TAB1 INNER JOIN RESOLUTION_TAB ON TAB1.COMP_NUM = RESOLUTION_TAB.COMP_NUM) ON TAB2.LOB = TAB1.NETWORK) LEFT JOIN SQLVIEW1 ON TAB1.COMP_NUM = SQLVIEW1.COMP_NUM
> WHERE<<<(((RESOLUTION_TAB.MBR_SAT)="Y") AND ((TAB1.USERTYPE)=1) AND ((TAB1.COMP_DATE) Between [forms]![summ_rpt_shm_frm]![begin] And [forms]![summ_rpt_shm_frm]![End])>>> AND ***((SQLVIEW1.SVCREGCODEID)=[forms]![summ_rpt_shm_frm]![cbosvcregion]))***
> GROUP BY Trim([TAB2].[LOB_DESC]) & " (" & Trim([TAB2].[LOB]) & ")"
> ORDER BY Trim([TAB2].[LOB_DESC]) & " (" & Trim([TAB2].[LOB]) & ")"
> PIVOT Format([COMP_DATE],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
> The code between <> is static and will always have a value.  I'm trying to add a dynamic parameter between the **s.
>