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 Exte
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 need to determine the average
> yield by variety, and figure ou
MAIL 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
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
Try something like this.
>
>
> #totaltrials#
> #variety#
> #avgyield#
#trialpercent# %
>
Is that what you are trying to do?
You can also use the NumberFormat(trialpercent, arg). You will want to look
it up to see how to set it to 1 or 2 decimal places.
- Original Message -
From: Dea
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
This might best be done
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?
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 yell at me
a
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?
-Original Message-
From: Deanna L. Schneider [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 26, 2000 9:53 AM
To: [EMAIL PROTECTED]
Subject: gr
8 matches
Mail list logo