Query into several records

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
It can be done, and typically it is done use code, which is either a Macro
or a Module.
 
Back
Top