[AccessD] Invalid Operation - Query

Hi
 
It may simply be too complex - I have recently seen this error a couple of
times when running queries based on other queries - switching some or all of
the queries from select statements to make-tables and running the meta-query
on the tables instead solved the problem.
 
HTH
 
Roz
 
-----Original Message-----
From: Kaup, Chester A [mailto:kaupca at chevrontexaco.com] 
Sent: 23 June 2003 20:45
To: accessd at databaseadvisors.com
Subject: [AccessD] Invalid Operation - Query
 
When I try to run the attached SQL I get a message of invalid operation.
This query basically sums together 6 queries that each sum up some daily
data. Any thoughts as to why the error?
SELECT Gomez_Fld.ACTVDATE,
Gomez_Fld!SumOfVOLUME_SS+Halley_Emp!SumOfVOLUME_SS+Other_FortStockton!SumOfV
OLUME_SS+Puckettl_Fld!SumOfVOLUME_SS+Waha_Fld!SumOfVOLUME_SS+[Warwink
Fld]!SumOfVOLUME_SS AS [Total Gas]
FROM ((((Gomez_Fld INNER JOIN Halley_Emp ON Gomez_Fld.ACTVDATE =
Halley_Emp.ACTVDATE) I 
NNER JOIN Other_FortStockton ON Gomez_Fld.ACTVDATE =
Other_FortStockton.ACTVDATE) 
INNER JOIN Waha_Fld ON Gomez_Fld.ACTVDATE = Waha_Fld.ACTVDATE) 
INNER JOIN [Warwink Fld] ON Gomez_Fld.ACTVDATE = [Warwink Fld].ACTVDATE) 
INNER JOIN Puckettl_Fld ON Gomez_Fld.ACTVDATE = Puckettl_Fld.ACTVDATE 
GROUP BY Gomez_Fld.ACTVDATE,
Gomez_Fld!SumOfVOLUME_SS+Halley_Emp!SumOfVOLUME_SS+Other_FortStockton!SumOfV
OLUME_SS+Puckettl_Fld!SumOfVOLUME_SS+Waha_Fld!SumOfVOLUME_SS+[Warwink
Fld]!SumOfVOLUME_SS
ORDER BY Gomez_Fld.ACTVDATE; 
No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030624/ae6bf5a1/attachment-0001.html>