[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

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

 

---In MS_Access_Professionals@yahoogroups.com, <statmanbp@yahoo.com> 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.

Ken

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___