B
Bill R via AccessMonster.com
Duane,
I'll try that.
Did you check out that thread? I have no familiarity with forms as datasheets,
which is why I was trying to avoid using them. Jesper said he had a workable
solution and Paul Overway apparently concurred. But I can't tell what "it" is
in his statement, "The first time it runs I create a crosstab query ..." and
I have no idea how he set up his subform.
Bill
I'll try that.
Did you check out that thread? I have no familiarity with forms as datasheets,
which is why I was trying to avoid using them. Jesper said he had a workable
solution and Paul Overway apparently concurred. But I can't tell what "it" is
in his statement, "The first time it runs I create a crosstab query ..." and
I have no idea how he set up his subform.
Bill
Duane said:I would use code to set the parameter values in the sql like:
strSQL = strSQL & "TRANSFORM ..." & vbCrLf
strSQL = strSQL & "SELECT ..." & vbCrLf
strSQL = strSQL & "FROM tblSwapParameters AS Params, Params2 " & vbCrLf
strSQL = strSQL & "WHERE swapid=" & [Forms]![frmSwaps]![SwapID] & vbCrLf
strSQL = strSQL & " And somefield=" & [Forms]![frmSwaps]![Conf95] & vbCrLf
strSQL = strSQL & " GROUP BY swapid, ..." & vbCrLf
strSQL = strSQL & " PIVOT CalcMonth;"
[quoted text clipped - 52 lines]Duane,