Hi,
In Access 2003 I have subform which is returning queried data in datasheet a datasheet view. The query has a right join and to limit data to where in 1 table and not in another with ‘IS NULL’. I want to be able to update manually update the combo box. Is this possible?
SELECT CRD_archive.UniqueID AS UniqueID, CRD_archive.[Fund Code] AS Fund_Code, CRD_archive.[Security Name] AS Security_Name, CRD_archive.[Security Code] AS Security_Code, CRD_archive.ISIN AS ISIN, CRD_archive.CUSIP AS CUSIP, CRD_archive.SEDOL AS SEDOL, CRD_archive.TICKER AS TICKER, CRD_archive.[Holding SOD] AS Holding_SOD, CRD_archive.[Market Value Intraday] AS Market_Value_Intraday, CRD_archive.[Market Value SOD] AS Market_Value_SOD, CRD_archive.[Exposure Amount] AS Exposure_Amount, CRD_archive.[Current Market Value Intraday] AS Current_Market_Value_Intraday, CRD_archive.EffectiveDate AS EffectiveDate, CRD_archive.StatRec AS StatRec, CRD_archive.Relevance AS Relevance, CRD_archive.StatHold AS StatHold, CRD_archive.Comments AS Comments
FROM CRD_load RIGHT JOIN CRD_archive ON CRD_load.ISIN=CRD_archive.ISIN
WHERE (((CRD_archive.StatRec)=1) AND ((CRD_archive.Relevance)=1) AND ((CRD_archive.StatHold)=0) AND ((CRD_load.UniqueID) Is Null));
thanks
