Calculations based on cross tab intersection values

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?


--
Carlee

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.

--
Duane Hookom
Microsoft Access MVP


"Carlee" wrote:

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?


--
Carlee

Hi Duane,
Here is my code:

PARAMETERS [forms]![frmReportMenu]![cboArea] Text ( 255 );
TRANSFORM (NZ(Count(qryReportRiskClassificationSummary.Submi ssionID),0)) AS
CountOfSubmissionID
SELECT qryReportRiskClassificationSummary.AgeAtSampling,
Count(qryReportRiskClassificationSummary.Submissio nID) 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" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"Carlee" wrote:

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?


--
Carlee

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" wrote:

Hi Duane,
Here is my code:

PARAMETERS [forms]![frmReportMenu]![cboArea] Text ( 255 );
TRANSFORM (NZ(Count(qryReportRiskClassificationSummary.Submi ssionID),0)) AS
CountOfSubmissionID
SELECT qryReportRiskClassificationSummary.AgeAtSampling,
Count(qryReportRiskClassificationSummary.Submissio nID) 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" wrote:

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.

--
Duane Hookom
Microsoft Access MVP


"Carlee" wrote:

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?


--
Carlee