Unanswered: How do I perform a 'make table' function on a parameter query?
I'm trying to use a make table query to make a table from a parameter query, but Access requests parameters before making the table. My parameter query reads two values in two unbound text boxes on a form. A command button on the form executes code that passes values to the unbound text boxes and then a report reads the results of the parameter query.
I also need to make a table from the parameter query that produced the report as part of this process (without being prompted from input of parameters by Access).