At Your Survey: Calculate field in cros-tab queries

[ButBi]

Sorry for my newbie question.
I want to use At Your Survey by Duane Hookom for one benchmarking
database. So I want to use cros tab queries with some calculate fields
to show the benchmarking.

I.e. I want to add some calculate fields to this query:

TRANSFORM First(tblResponses.Rspns) AS FirstOfRspns
SELECT tblSrvRspns.RspnsName AS Respondent
FROM tblSrvRspns INNER JOIN (tblQuestions INNER JOIN tblResponses ON
tblQuestions.QstnID = tblResponses.QstnID) ON tblSrvRspns.RspnsID =
tblResponses.RspnsID
GROUP BY tblSrvRspns.RspnsName
PIVOT tblQuestions.QstnBrief;

in order to show the answers as well as the calculated values (i.e.
answer 1 + answer 3).

Can some body help me and explain me how to do that. Any hint is
appreciated.

 

[Duane Hookom]

I'm not sure I understand your question. Could you provide a small sample of
your records and how you would expect them to be displayed?