IIf([NRate]>0,[NRate],[HourRate]) AS NewRate

Try this and it will work (one field from you query):

CASE NRATE >0 THEN NRATE ELSE HOURRATE AS NEWRATE