Query into several records

[Guest]

I have a query made from a table(and a form made from the query). When I
update a new record, the equation in the query calculates a PMT. I want
another query to pull up that PMT automatically and calculate a result based
on the number of periods.

If I enter 20 periods in a field in the first query, I want the new query to
spit out 20 records with the same PMT on every record. Can this be done and
how?

 

[[MVP] S.Clark]

It can be done, and typically it is done use code, which is either a Macro
or a Module.