This should be an easy one but my query is either showing a blank or producing an error when i try to use it for my report.
I'm trying to pull two values from an existing query, then replace any null value for AirGainLoss with a 0.
I'm trying to pull two values from an existing query, then replace any null value for AirGainLoss with a 0.
SQL:
SELECT qryRGainLoss15Report.AirlineCompanyLookup, qryRGainLoss15Report.AirGainLoss, Nz([AirGainLoss]) AS AirGainLossNz
FROM qryRGainLoss15Report
GROUP BY qryRGainLoss15Report.AirlineCompanyLookup, qryRGainLoss15Report.AirGainLoss;/CODE]
What am i doing wrong?