automate a part of an Append qry

[JR]

I have an append query that requires the definition of
two "parameters" as it executes.

The problem is that each time I run it I have to manually
enter the two parameters. There are 20 different
combinations and so the query has to be executed 20
separate times.

Is there a way to automate the process?

The table it writes to is laid out as follows

Item ID | Alpha-Numeric
Location | Alpha
Posture* | Alpha
Phase* | Alpha
Rate | Number

*Posture and Phase are the columns that must be manually
entered as parameters when a pop-up prompt asks for a
parameter. The manual entry of that parameter is what I
want to automate.

 

[Jeff Boyce]

?You have the need to repeatedly write records to a table, based on the same
set/combination of parameters?

I'm trying to envision why...

Could you describe a bit more about what you are trying to accomplish
overall, rather than how?

 

[JR]

The target table gets rewritten as data in feeder tables
and queries changes which happens at least monthly.

The target table is then sent to some modelers who use the
table to feed their model.

JR