The query below is returning a line 10 extra times when satisfying the IIF clause, so i get 11 entries total per matching record.....advice?
SELECT tbl_BSecNNM.Rep
, tbl_BSecNNM.AccountNum
, tbl_BSecNNM.AccountName
, tbl_BSecHH.HHID
, tbl_BSecHH.HHName
, tbl_BSecNNM.NNMLY
, tbl_BSecNNM.NNMYTM
, tbl_BSecNNM.NetNewMoney
, tbl_BSecNNM.AUM
, IIf(tbl_BSecFeeAccounts.AccountNum Is Null,"n","y") AS FeeBased INTO tbl_NB_Bsec
FROM ((tbl_BSecNNM
LEFT OUTER JOIN tbl_BSecFeeAccounts
ON
tbl_BSecNNM.AccountNum=tbl_BSecFeeAccounts.Account Num)
LEFT OUTER JOIN tbl_BsecHH
ON
tbl_BSecNNM.AccountNum=tbl_BsecHH.AccountNum)
;