Hi, I'm looking for a way in Microsoft Query 2002 to
convert Null values in a field to "0" before exporting to
Microsoft Excel 2002.

For example, in the following query, I need to set
`Tables$TM_ETF_Scan`.`'ETF 1Wk RS'` and similar fields
to "0" before exporting to Excel.

SELECT `Tables$Swing_B`.`TICKER SYMBOL`,
`Tables$Swing_B`.`SECURITY NAME`, `Tables$Swing_B`.`SWING
WAVE`, `Tables$Swing_B`.`CONNORS WINDOW`,
`Tables$Swing_B`.`'EPS RS'`, `Tables$Swing_B`.`'Stk 3 Mo
RS'`, `Tables$Swing_B`.`'Stk 6 Mo RS'`,
`Tables$Swing_B`.`'Stk 12 Mo RS'`,
`Tables$TM_ETF_Scan`.`'ETF 1Wk RS'`,
`Tables$TM_ETF_Scan`.`'ETF 1Mo RS'`,
`Tables$TM_ETF_Scan`.`'ETF 3Mo RS'`,
`Tables$TM_ETF_Scan`.`'ETF 6Mo RS'`,
`Tables$TM_ETF_Scan`.`'ETF 12Mo RS'`
FROM {oj `Tables$Swing_B` `Tables$Swing_B` LEFT OUTER JOIN
`Tables$TM_ETF_Scan` `Tables$TM_ETF_Scan` ON
`Tables$Swing_B`.`TICKER SYMBOL` =
`Tables$TM_ETF_Scan`.Symbol}


Thanks,
David