I'm so confused with this one...
I'm trying to follow the sequence of events in this Db so I know what parts of the db I need to keep and what I can delete.
This UPDATE query appears to update another query based on its relationship with a table - (I get that queries are just tables themselves)
But I've never seen this before, or at least not written quite this way...
Anyway here are the queries
This is triggered by a DoCmd.OpenQuery Event
Code:
UPDATE qryRefDLYsubCR RIGHT JOIN tbl_DLYtmp ON qryRefDLYsubCR.date = tbl_DLYtmp.Date SET tbl_DLYtmp.RefCRttl = qryRefDLYsubCR.RefCRttl,
tbl_DLYtmp.RefCR2day = qryRefDLYsubCR.RefCR2day, tbl_DLYtmp.RefCR3day = qryRefDLYsubCR.RefCR3day
Here is the Query [qryRefDLYsubCR] referenced in the above query
Code:
SELECT CDate([F1]) AS [date], CInt([F2]) AS RefCRttl, CInt([F5]) AS RefCR2day, CInt([F7]) AS RefCR3day
FROM tmpRefWTDCR
WHERE (((CDate([F1]))<Date()) AND ((IsDate([F1]))=-1));
I'm completely confused on how to read this
Help???