[AccessD] Query gives invalid operation error

Kaup, Chester A kaupca at chevrontexaco.com
Fri Sep 24 11:16:39 CDT 2004


The following query gives an invalid operation error. Each of the
queries it is based on runs fine. Any ideas?

SELECT [qry Ft Stockton Other Fields Gas].ACTVDATE, [qry Ft Stockton
Other Fields Gas]![SumOfVOLUME_SS]+[qry Gomez Field
Gas]![SumOfVOLUME_SS]+[qry Halley Field Gas]![SumOfVOLUME_SS]+[qry Waha
Field Gas]![SumOfVOLUME_SS]+[qry Warwink Field
Gas]![SumOfVOLUME_SS]+[qry Sandhills Gas]![SumOfVOLUME_SS] AS MCFPD,
[qry Ft Stockton Other Fields Gas]![NWI Gas]+[qry Gomez Field
Gas]![SumOfVOLUME_SS]+[qry Halley Field Gas]![SumOfVOLUME_SS]+[qry Waha
Field Gas]![SumOfVOLUME_SS]+[qry Warwink Field
Gas]![SumOfVOLUME_SS]+[qry Sandhills Gas]![NWI Gas] AS [NWI MCFPD]
FROM [qry Sandhills Gas] INNER JOIN ([qry Gomez Field Gas] INNER JOIN
((([qry Ft Stockton Other Fields Gas] INNER JOIN [qry Halley Field Gas]
ON [qry Ft Stockton Other Fields Gas].ACTVDATE = [qry Halley Field
Gas].ACTVDATE) INNER JOIN [qry Waha Field Gas] ON [qry Ft Stockton Other
Fields Gas].ACTVDATE = [qry Waha Field Gas].ACTVDATE) INNER JOIN [qry
Warwink Field Gas] ON [qry Ft Stockton Other Fields Gas].ACTVDATE = [qry
Warwink Field Gas].ACTVDATE) ON [qry Gomez Field Gas].ACTVDATE = [qry Ft
Stockton Other Fields Gas].ACTVDATE) ON [qry Sandhills Gas].ACTVDATE =
[qry Ft Stockton Other Fields Gas].ACTVDATE;

Chester Kaup
Information Management Technician
IT-MidContinent/MidContinent Business Unit
CTN 8-687-7415  
Outside 432-687-7414

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced. 






More information about the AccessD mailing list