Senin, 11 April 2016

[MS_AccessPros] Re: Select all records of form


You would use an update query something like this:

UPDATE myTable
SET IssueDate = DateAdd("d", 1, IssueDate)
WHERE IssueStatus = 'Open

Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog


---In, <> wrote :

I am using a issues database and want to create a button to update all open issues dates by one.  It is easy to update one record by how do I update all open issues at the same time.  Thanks for the help.



Posted by:
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)



Tidak ada komentar:

Posting Komentar