Gustav Brock
gustav at cactus.dk
Fri Sep 24 11:37:56 CDT 2004
Hi Chester Could it be these fields: [NWI Gas] All other you add seem to be Sums. Try wrapping it in Nz(): + Nz([NWI Gas], 0) /gustav > 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;