At Your Survey: Calculate field in cros-tab queries

B

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.
 
D

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

At Your Survey: Calculate field in cros-tab queries (followup) 5
Crosstab query ODBC Fails - AYS2000 3
Problem with parameter query 11
Expression typed incorrectly ... 8
Survey Queries in Access 5
At Your Survey: import data from existing Excel table? 9
Expression typed incorrectly .... wierd query behavior 1
Problem with criteria in cros tab query 2

Top