Calculations based on cross tab intersection values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have created a cross tab query that gives me a serious of values based on
a column and row intersection.

Question: I need to make addition calculations based on various calculation
in the crosstab results. for example if the intersection of my Age Row, and
Category Column = 20, i want to be able to identify 20 in a subsequent query
to make an additional calculation. How do i do this?
 
You should be able to grab a value by un-pivoting the crosstab. I could
probably explain better if you provided the sql view and the values and
fields you wanted to lookup up.
 
Hi Duane,
Here is my code:

PARAMETERS [forms]![frmReportMenu]![cboArea] Text ( 255 );
TRANSFORM (NZ(Count(qryReportRiskClassificationSummary.SubmissionID),0)) AS
CountOfSubmissionID
SELECT qryReportRiskClassificationSummary.AgeAtSampling,
Count(qryReportRiskClassificationSummary.SubmissionID) AS [Total Of
SubmissionID]
FROM qryReportRiskClassificationSummary
GROUP BY qryReportRiskClassificationSummary.AgeAtSampling
PIVOT qryReportRiskClassificationSummary.Classification;




Thank you so much in advance...you may be able to save my butt...!
 
You should be able to query on AgeAtSampling and Classification to get the
Total...

PARAMETERS [forms]![frmReportMenu]![cboArea] Text ( 255 );
SELECT AgeAtSampling, Classification,
Count(SubmissionID) AS [Total Of SubmissionID]
FROM qryReportRiskClassificationSummary
GROUP BY AgeAtSampling, Classification

--
Duane Hookom
Microsoft Access MVP


Carlee said:
Hi Duane,
Here is my code:

PARAMETERS [forms]![frmReportMenu]![cboArea] Text ( 255 );
TRANSFORM (NZ(Count(qryReportRiskClassificationSummary.SubmissionID),0)) AS
CountOfSubmissionID
SELECT qryReportRiskClassificationSummary.AgeAtSampling,
Count(qryReportRiskClassificationSummary.SubmissionID) AS [Total Of
SubmissionID]
FROM qryReportRiskClassificationSummary
GROUP BY qryReportRiskClassificationSummary.AgeAtSampling
PIVOT qryReportRiskClassificationSummary.Classification;




Thank you so much in advance...you may be able to save my butt...!

--
Carlee


Duane Hookom said:
You should be able to grab a value by un-pivoting the crosstab. I could
probably explain better if you provided the sql view and the values and
fields you wanted to lookup up.
Click to expand...
Click to expand...
 
Back
Top