Re: Use crosstab column heading in a calculation

Tech-Archive recommends: Fix windows errors by optimizing your registry

I believe their solution is to assign the crosstab query as the object
source of the control on the main form.

--
Duane Hookom
MS Access MVP
--

"Bill R via AccessMonster.com" <u9289@uwe> wrote in message
news:5a8e766574b8b@xxxxxx
> 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
>
> Duane Hookom wrote:
>>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;"
>>
>>> Duane,
>>>
>>[quoted text clipped - 52 lines]
>>>>>>>>>>>>
>>>>>>>>>>>> Bill
>
> --
> Bill Reed
>
> "If you can't laugh at yoursel, laugh at somebody else"
>
> Message posted via http://www.accessmonster.com


.

Quantcast