Update query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon Glencross - 11 Sep 2006 21:41 GMT

I have the following update query

UPDATE tblcustomers INNER JOIN tblservice ON tblcustomers.ID =
tblservice.CustomerID SET tblservice.ServiceReminderSent = False
WHERE (((tblservice.ActDateCompleted) Is Null));

What I want to also be able to do is select only records with the current
date in the sentdate field.

Any suggestions please?

Reply to this Message

John Spencer - 12 Sep 2006 00:46 GMT

UPDATE tblcustomers INNER JOIN tblservice
ON tblcustomers.ID = tblservice.CustomerID
SET tblservice.ServiceReminderSent = False
WHERE (((tblservice.ActDateCompleted) Is Null)) AND SentDate = Date()

If I didn't qualify the table for SentDate since you didn't say which table it
is in.

If SentDate also contains the time, then modify this to
... And SentDate Between Date() and Date()+1

You could, in theory end up with a record that was sent at exactly midnight of
the following day, but in most cases that is an unlikely event.

> I have the following update query
>
[quoted text clipped - 6 lines]
>
> Any suggestions please?

Reply to this Message