Is it possible to do the following:
1. Use a form to do a SELECT query and display the results in the form
2. Take those SELECT query results in the form and add a field with a value, then turn all of that into an APPEND query so that a table can be appended.
Is this possible?