Crosstab Parameter Decleration

[AccessARS]

Hello,

I have been researching this for couple of days and with some trial and
error managed to build this croostab statement. Unfortunately my parameter
declaration gives me an error:

Invalid bracketing of Name '[Forms]!Overview![ExecDash]'

The purpose of this paramameter is to requery the crosstab on the LOB field
once the ExecDash unbound field value on the Overview form changes. Whether
it's populated or Null which is addressed by "Like *" in the where clause...

PARAMETERS [[Forms]!Overview![ExecDash]] Text ( 255 );
TRANSFORM Sum(qry_WF_HC_PART1.CountOfPernr) AS Total
SELECT qry_WF_HC_PART1.LOB
FROM qry_WF_HC_PART1
WHERE (((qry_WF_HC_PART1.LOB) Like "*" & [Forms]![Overview]![ExecDash]))
GROUP BY qry_WF_HC_PART1.LOB
PIVOT qry_WF_HC_PART1.EmployeeLevel;


Your input/direction would be greatly appreciated.

Thank you.

 

[Duane Hookom]

You need to remove a pair of square brackets from around the PARAMETER. I
have experienced Access automatically adding these extra brackets and then
complaining. This has usually been when converting to a newer version.

PARAMETERS [Forms]!Overview![ExecDash] Text ( 255 );
TRANSFORM Sum(qry_WF_HC_PART1.CountOfPernr) AS Total
SELECT qry_WF_HC_PART1.LOB
FROM qry_WF_HC_PART1
WHERE (((qry_WF_HC_PART1.LOB) Like "*" & [Forms]![Overview]![ExecDash]))
GROUP BY qry_WF_HC_PART1.LOB
PIVOT qry_WF_HC_PART1.EmployeeLevel;

 

[AccessARS]

Thank you...that seemed to resolve the issue.

You need to remove a pair of square brackets from around the PARAMETER. I
have experienced Access automatically adding these extra brackets and then
complaining. This has usually been when converting to a newer version.

PARAMETERS [Forms]!Overview![ExecDash] Text ( 255 );
TRANSFORM Sum(qry_WF_HC_PART1.CountOfPernr) AS Total
SELECT qry_WF_HC_PART1.LOB
FROM qry_WF_HC_PART1
WHERE (((qry_WF_HC_PART1.LOB) Like "*" & [Forms]![Overview]![ExecDash]))
GROUP BY qry_WF_HC_PART1.LOB
PIVOT qry_WF_HC_PART1.EmployeeLevel;

--
Duane Hookom
Microsoft Access MVP

Hello,

I have been researching this for couple of days and with some trial and
error managed to build this croostab statement. Unfortunately my parameter
declaration gives me an error:

Invalid bracketing of Name '[Forms]!Overview![ExecDash]'

The purpose of this paramameter is to requery the crosstab on the LOB field
once the ExecDash unbound field value on the Overview form changes. Whether
it's populated or Null which is addressed by "Like *" in the where clause...

PARAMETERS [[Forms]!Overview![ExecDash]] Text ( 255 );
TRANSFORM Sum(qry_WF_HC_PART1.CountOfPernr) AS Total
SELECT qry_WF_HC_PART1.LOB
FROM qry_WF_HC_PART1
WHERE (((qry_WF_HC_PART1.LOB) Like "*" & [Forms]![Overview]![ExecDash]))
GROUP BY qry_WF_HC_PART1.LOB
PIVOT qry_WF_HC_PART1.EmployeeLevel;


Your input/direction would be greatly appreciated.

Thank you.