mickmullen
Registered User.
- Local time
- Today, 08:21
- Joined
- Oct 30, 2018
- Messages
- 19
I have a form where I push a button and some code runs and generates the SQL for a query.
I'm looking for a way to automate a check in a yes/No "completed" field in a sales table based upon the results of that query.
For example the query generates a table of
Product A, Room 1, Job Z.
Product B, Room 1 Job Z
Product A, Room 2, Job Z
Theres a sales table that has sales amount info for line items that match each of these "Rows" (not sure how you say it in access talk- criteria?)
How do I get the Sales Table to add a check mark in the "completed" field where each matching line item in the query matches the table? Ideally it happens when I check a control on the form.
Is this an append query?
I'm looking for a way to automate a check in a yes/No "completed" field in a sales table based upon the results of that query.
For example the query generates a table of
Product A, Room 1, Job Z.
Product B, Room 1 Job Z
Product A, Room 2, Job Z
Theres a sales table that has sales amount info for line items that match each of these "Rows" (not sure how you say it in access talk- criteria?)
How do I get the Sales Table to add a check mark in the "completed" field where each matching line item in the query matches the table? Ideally it happens when I check a control on the form.
Is this an append query?