Here's what I'm trying to do.

TblFidNCS and two feilds, AssetID and FAssetID. These fields need to be
compared to the AssetID feild in TblBkData. We need to see if the feild in
TblBkData matches either AssetID of FAssetID in TblFidNCS.

If we have a match for the ID, but we do not have a match for the Ex field I
need the result to come up in a query.

Here's the bad code I've written below that will hopefully give you an idea
of my problem:

SELECT TblBkData.AssetID, TblBkData.AType, TblBkData.Ex, TblBkData.Rec,
TblBkData.Pay, TblBkData.Tax, TblBkData.GRate, TblBkData.Ctry,
TblBkData.Curr, TblBkData.Src, TblBkData.AnDt, TblBkData.AmDt
FROM TblBkData, TblFidNCS
WHERE (((TblBkData.AssetID)=[TblFidNCS].[FAssetID]) AND
((TblBkData.Ex)<>[TblFidNCS].[Ex])) OR
(((TblBkData.AssetID)=[TblFidNCS].[AssetID]) AND
((TblBkData.Ex)<>[TblFidNCS].[Ex]));

Here's a little visual of what I'm shooting for to report on in the query

            TblFidNCS                                        TblBkData
AssetID            FAssetID            Ex            AssetID            Ex
123456789       987654321        6/5          123456789        7/10