Kaup, Chester
Chester_Kaup at kindermorgan.com
Tue Aug 9 16:13:50 CDT 2005
This query is asking for input of [qry Pattern WAG Scheme]![Cum_Toti_hcpv] yet this query when I run it by itself does not. Maybe a query syntax error but I don't see it. SELECT [tbl Actual Injectivities Daily].Pattern, [tbl Actual Injectivities Daily].Date, [tbl Actual Injectivities Daily].[TotI (%HCPV/Yr)], (Select Fluid from [tbl Wag] where [qry Pattern WAG Scheme]![Cum_Toti_hcpv] = (Select Max (Cum_Toti_hcpv) from [qry Pattern WAG Scheme] where [qry Pattern WAG Scheme]![Cum_Toti_hcpv] <= [tbl Actual Injectivities Daily]![TotI (%HCPV/Yr)] )) AS FluidType FROM [tbl Actual Injectivities Daily]; Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.