When I do my other "Select" queries and make changes to the data from the queries my table data is changed. However the query below will not allow me to make changes. The data from the query is correct but can't make changes to it. One post said to change Record Set type to "dynaset" or "dynaset (inconsistent updates) and neither worked. Otherwise I have to go to 200 individual records and make the changes. Any help would be most appreciated-Thank you--
SELECT TBLOCCMain.Year, TBLOCCMain.OCCNumber, Min(TBLLinkCounDate.[In OCC]) AS [MinOfIn OCC], TBLOCCMain.AssignType
FROM TBLOCCMain LEFT JOIN TBLLinkCounDate ON TBLOCCMain.OCCNumber = TBLLinkCounDate.OCCNumber
GROUP BY TBLOCCMain.Year, TBLOCCMain.OCCNumber, TBLOCCMain.AssignType
HAVING (((TBLOCCMain.Year)<>"FY06") AND ((Min(TBLLinkCounDate.[In OCC])) Between #10/1/2005# And #9/30/2006#) AND ((TBLOCCMain.AssignType)="c"));
SELECT TBLOCCMain.Year, TBLOCCMain.OCCNumber, Min(TBLLinkCounDate.[In OCC]) AS [MinOfIn OCC], TBLOCCMain.AssignType
FROM TBLOCCMain LEFT JOIN TBLLinkCounDate ON TBLOCCMain.OCCNumber = TBLLinkCounDate.OCCNumber
GROUP BY TBLOCCMain.Year, TBLOCCMain.OCCNumber, TBLOCCMain.AssignType
HAVING (((TBLOCCMain.Year)<>"FY06") AND ((Min(TBLLinkCounDate.[In OCC])) Between #10/1/2005# And #9/30/2006#) AND ((TBLOCCMain.AssignType)="c"));