[AccessD] Updateable query

Dear Group,

I may have answered my own question. I did another MakeTable query that just stored the LogIDs generated by the query I posted. Then I made this query which DID produce an updateable recordset:

SELECT T.LogID, T.ClientID, T.ServiceDate, T.ServiceCode, T.Hours
FROM tblServiceLog AS T 
WHERE (((T.LogID) In (SELECT [_OrphansIDs].LogID
FROM _OrphansIDs;)));

Now, if I can just do this without making any temporary tables...


Sincerely,

Steve Erbach
Scientific Marketing
Neenah, WI
920-969-0504