making into update query

[tom4038]

i have this query which returns correct results,which i managed to put together after a few hours!!

SELECT Max(qryAllALARMS.SentTimeStamp) AS MaxDate, qryAllALARMS.PhoneNumber
FROM qryAllALARMS
GROUP BY qryAllALARMS.PhoneNumber
HAVING (((Max(qryAllALARMS.SentTimeStamp))<Date()-"7"));

Now need it to update a table, unitDetails.Status with "pending", so it needs to be an update query??

qryAllALARMS.PhoneNumber will match unitDetails.phonenumber, sorry about my terminology, im new to all this

I have tried to build a query below but didnt get far!


UPDATE unitDetails SET unitDetails.Status = "Pending"
WHERE wot next here ??

[RuralGuy]

I'm not sure how your query is working correctly since this line:
HAVING (((Max(qryAllALARMS.SentTimeStamp))<Date()-"7"));
...is subtracting a string "7" from a number Date()