Re: A rookie needs a patient teacher

Yow -

Here's a formatted version:
SELECT
tblResults.SesID
, Count(tblResults.ResID) AS n
, Avg(tblResults.Tchol2) AS TChol1Av
, Count(tblResults.Tchol2) AS nChol1
, Min(tblResults.Tchol2) AS TChol1min
, Max(tblResults.Tchol2) AS Tchol1max
, Avg(tblResults.HDL2) AS HDL1Av
, Count(tblResults.HDL2) AS nHDL1
, Min(tblResults.HDL2) AS HDL1min
, Max(tblResults.HDL2) AS HDL1max
, Avg(qryRatioResults.Ratio2) AS Ratio1Av
, Count(qryRatioResults.Ratio2) AS nRatio1
, Min(qryRatioResults.Ratio2) AS Ratio1min
, Max(qryRatioResults.Ratio2) AS Ratio1max
, Avg(tblResults.LDL2) AS LDL1Av
, Count(tblResults.LDL2) AS nLDL1
, Min(tblResults.LDL2) AS LDL1min
, Max(tblResults.LDL2) AS LDL1max
, Avg(tblResults.TG2) AS TG1Av
, Count(tblResults.TG2) AS nTG1
, Min(tblResults.TG2) AS TG1min
, Max(tblResults.TG2) AS TG1max
, Avg(tblResults.Glu2) AS GLu1Av
, Count(tblResults.Glu2) AS nGlu1
, Min(tblResults.Glu2) AS Glu1min
, Max(tblResults.Glu2) AS glu1max
, Avg(tblResults.Wt2) AS Wt1Av
, Count(tblResults.Wt2) AS nWT1
, Min(tblResults.Wt2) AS Wt1min
, Max(tblResults.Wt2) AS Wt1max
, Avg(tblResults.BMI2) AS BMI1Av
, Count(tblResults.BMI2) AS nBMI1
, Min(tblResults.BMI2) AS BMI1min
, Max(tblResults.BMI2) AS BMI1max
, Avg(tblResults.BPsys2) AS BPsys1Av
, Count(tblResults.BPsys2) AS nBPsys1
, Min(tblResults.BPsys2) AS BPsys1min
, Max(tblResults.BPsys2) AS BPsys1max
, Avg(tblResults.BPdia2) AS BPdia1Av
, Count(tblResults.BPdia2) AS nBPdia1
, Min(tblResults.BPdia2) AS BPdia1min
, Max(tblResults.BPdia2) AS BPdia1max
, Avg(tblResults.Pulse2) AS Puls1Av
, Count(tblResults.Pulse2) AS nPuls1
, Min(tblResults.Pulse2) AS Pulse1min
, Max(tblResults.Pulse2) AS Pulse1max
, Avg(tblResults.ResInfo02) AS BFP2Av
, Count(tblResults.ResInfo02) AS nBFP2
, Min(tblResults.ResInfo02) AS BFP2Min
, Max(tblResults.ResInfo02) AS BFP2max
, Avg(tblResults.ResInfo04) AS Ins2Av
, Count(tblResults.ResInfo04) AS nIns2
, Min(tblResults.ResInfo04) AS Ins2Min
, Max(tblResults.ResInfo04) AS Ins2max
, Avg(tblResults.ResInfo06) AS HgA1c2Av
, Count(tblResults.ResInfo06) AS nHgA1c2
, Min(tblResults.ResInfo06) AS HgA1c2Min
, Max(tblResults.ResInfo06) AS HgA1c2max
, Avg(tblResults.ResInfo08) AS Waist2Av
, Count(tblResults.ResInfo08) AS nWaist2
, Min(tblResults.ResInfo08) AS Waist2Min
, Max(tblResults.ResInfo08) AS Waist2max
, Avg(tblResults.ResInfo10) AS Hip2Av
, tblResults.ResInfo10 AS nHip2
, Min(tblResults.ResInfo10) AS Hip2Min
, Max(tblResults.ResInfo10) AS Hip2max
, Avg(tblResults.ResInfo12) AS WHRatio2Av
, Count(tblResults.ResInfo12) AS nWHRatio2
, Min(tblResults.ResInfo12) AS WHRatio2Min
, Max(tblResults.ResInfo12) AS WHRatio2max
FROM
tblResults
INNER JOIN
qryRatioResults
ON
tblResults.ResID = qryRatioResults.ResID
GROUP BY
tblResults.SesID
, tblResults.ResInfo10;

Denise wrote:
I think you asked for the same thing as Jerry - correct? It's posted.

Denise-

[quoted text clipped - 22 lines]

Gratefully,

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200805/1

.