[AccessD] Query asks for input - why?

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Aug 9 16:23:51 CDT 2005


I found the problem. A wrong table name. Thanks to anyone who looked.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, August 09, 2005 4:14 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Query asks for input - why?

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.

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list