[AccessD] Query gives invalid operation error

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;