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.