If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Crosstab Parameter Decleration
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. |
#2
|
|||
|
|||
Crosstab Parameter Decleration
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 "AccessARS" wrote: 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. |
#3
|
|||
|
|||
Crosstab Parameter Decleration
Thank you...that seemed to resolve the issue.
"Duane Hookom" wrote: 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 "AccessARS" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|