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. |
Thread Tools | |
Display Modes | |
|
|