Re: grouping with math functions

2000-05-26 Thread Deanna L. Schneider
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

Re: grouping with math functions

2000-05-26 Thread John Westerlund
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

Re: grouping with math functions

2000-05-26 Thread John Westerlund
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

Re: grouping with math functions

2000-05-26 Thread Deanna L. Schneider
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

Re: grouping with math functions

2000-05-26 Thread John Westerlund
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

RE: grouping with math functions

2000-05-26 Thread mherbene
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

Re: grouping with math functions

2000-05-26 Thread Deanna L. Schneider
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

RE: grouping with math functions

2000-05-26 Thread mherbene
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