ACGF.org Contact UsACGF.org LinksACGF.org Financial GivingACGF.org ProgramsACGF.org Officers & Directors
 
 
 
<% If Request.QueryString("stateid")<> "" Then tempstateid = Request.QueryString("stateid") set rs_getStateResults = acfg_connection.execute("SELECT Count(MailingList.State) AS CountOfState, MailingList.State, " & _ "Count(MailingList.[Requiring Segregation]) AS StateElevRequiring_Segregation, " & _ "Count(MailingList.[Suggesting Secregation]) AS StateElevSuggesting_Secregation, " & _ "Count(MailingList.[Required Farmer to Segregate]) AS StateElevRequiredFarmerToSegregate, " & _ "Count(MailingList.[Suggested Farmer Segregate]) AS StateElevSuggestedFarmerSegregate, " & _ "Count(MailingList.[Schedule Delivery]) AS StateElevScheduleDelivery, " & _ "Count(MailingList.[Offering Premium on Non-GMO's]) AS StateElevOfferingPremium, " & _ "Count(MailingList.[Discounting GMO's]) AS StateElevDiscountingGMOCorn, " & _ "Max(MailingList.[Amount of Premium]) AS MaxOfAmountOfPremium " & _ "FROM MailingList " & _ "GROUP BY State " & _ "HAVING MailingList.State=('"&tempstateid&"')") %>
<% End If %>
2004 State Elevator Survey Results: <%= rs_getStateResults("State") %>
Elevators Requiring Segregation <%= rs_getStateResults("StateElevRequiring_Segregation") %>
Elevators Suggesting Segregation <%= rs_getStateResults("StateElevSuggesting_Secregation") %>
Elevators Require Farmers to Segregate <%= rs_getStateResults("StateElevRequiredFarmerToSegregate") %>
Elevators Suggest Farmers Segregate <%= rs_getStateResults("StateElevSuggestedFarmerSegregate") %>
Elev. Require Farmers to Schedule Delivery <%= rs_getStateResults("StateElevScheduleDelivery") %>
Elevators Offering Premiums <%= rs_getStateResults("StateElevOfferingPremium") %>
Range of Premiums <%= rs_getStateResults("MaxOfAmountOfPremium") %>
Elevators Discounting GMO Corn <%= rs_getStateResults("StateElevDiscountingGMOCorn") %>
Total Elevators Survey – <%= rs_getStateResults("State") %>    <%= rs_getStateResults("CountOfState") %>
     
">

 
<% set rs_getresults = acfg_connection.execute("SELECT Count(State) AS CountOfState, " & _ "State FROM MailingList GROUP BY State ") %>

1730 M. Street, NW, Suite 911
Washington, DC 20036
202-835-0023 Voice - 202-659-5760 Fax

Contact Us - Click Here

| Home | Contact Us | Links | Programs | Officers & Directors | Financial Giving |