example: SELECT consumption_import.accountName, CLng([consumption_import].[mainAccountID]) AS mainAccountID, consumption_import.mainAccountName, CDate(Mid(Replace([consumption_import].[accountDate],"T"," "),1,19)) AS accountDate, IIf([accountShareCrm] Is Null Or [accountShareCrm]=0 Or Not IsNumeric([accountShareCrm]),IIf([mainAccountShareCrm] Is Null Or [mainAccountShareCrm]=0 Or Not IsNumeric([mainAccountShareCrm]),Null,CDbl([mainAccountShareCrm])), CDbl([accountShareCrm])) AS combinedShareCrm FROM consumption_import;

convert