Okay, let me re-state my question of yesterday.
I have the results of a query printing out like so:
h3Side By Side Results/h3
cfoutput query="getaggresults2" group="standage"
h4Stand Age: #standage# Year/h4
table cellpadding="5"
tr
thTotal Trials/th
thVariety/th
thYield/th
/tr
cfoutput
tr
: grouping with math functions
Okay, let me re-state my question of yesterday.
I have the results of a query printing out like so:
h3Side By Side Results/h3
cfoutput query="getaggresults2" group="standage"
h4Stand Age: #standage# Year/h4
table cellpadding="5"
tr
snip
This might best be done within the SQL statement . Can you give us a little
more detail about the table and what fields need to be divided by what?
/snip
Okay, you asked for it. The SQL is a total mess. It's an access database
that someone else designed. So, here's the sql (don't anyone
No yelling - but can you explain what you want as a final result, based on
these queries?
-Original Message-
From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 10:16 AM
To: [EMAIL PROTECTED]
Subject: Re: grouping with math functions
snip
This might best
to see how to set it to 1 or 2 decimal places.
- Original Message -
From: Deanna L. Schneider [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 26, 2000 6:53 AM
Subject: grouping with math functions
Okay, let me re-state my question of yesterday.
I have the results of a query
What I want is the to get all the trials that have BOTH variety 1 and
variety 2 (chosen by the user) and that also meet the state and year
criteria (also chosen by the user). Then, I need to determine the average
yield by variety, and figure out the percent of variety one, by variety two
for each
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 26, 2000 7:48 AM
Subject: Re: grouping with math functions
What I want is the to get all the trials that have BOTH variety 1 and
variety 2 (chosen by the user) and that also meet the state and year
criteria (also chosen by the user). Then, I
with math functions
What I want is the to get all the trials that have BOTH variety 1 and
variety 2 (chosen by the user) and that also meet the state and year
criteria (also chosen by the user). Then, I need to determine the average
yield by variety, and figure out the percent of variety one
Oh yea! I'm glad to hear that what I'm trying to do is actually complex, and
it's not just my work-fried brain. ;)
Thanks for the help. I'll see where it gets me.
-d
Deanna Schneider
Interactive Media Developer
UWEX Cooperative
9 matches
Mail list logo