CODEWITHSUNDEEP
sqlms-accesssql-update
GettingStarted
GettingStarted

Reputation: 7605

How can I update the table based on a SELECT query?

 SELECT SignIn.[VisitorFirstName], SignIn.[VisitorLastName], SignIn.[SignInDateTime]
FROM SignIn
WHERE SignIn.SignInDateTime Is Null;

This provides me with a list of records that have no SignIn time. I want to update them automatically to make the date/time a week from today

How can I do this? I am using MS-ACCESS 2013

Upvotes: 1

Views: 55

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269933

You would use update:

update SignIn
    set SignInDateTime = dateadd('d', 1, DATE())
    where SignInDateTime is null;

Upvotes: 2

Related Questions