Menu
Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Beginners
2 linked rookie Q's - filling fields and moving records
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Arvin Meyer MVP, post: 1982685"] Assuming you have a field for knowing which records to mail (Mailed) UPDATE tblMyData SET tblMyData.DateSent = Date() WHERE (((tblMyData.DateSent) Is Null) AND ((tblMyData.Mailed)=True)); where tblMyData is the name of your table. Why would you want to? The Mailed field is more relational than using separate tables to store the same data. But to answer your question, yes, run an append query and a delete query. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Beginners
2 linked rookie Q's - filling fields and moving records
Top
