-
Assign Values Automatically from Queries
Hi there. I'm facing a problem with my database here.
I have queries to run records which do not match from 2 tables. These 2 tables are not related.
1. The records are considered closed orders so how do I get MS Access to update the status field in my Master Table as "Closed" automatically.
2. There are records that are new orders and I want to insert them into my Master Table for more monitoring. How do I insert these records that are ran from a query then?
Any advice and assistance is much appreciated.
Thanks a lot in advance.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|