I have a loan amort table. The table is generated by a temporary query. The temp qry has all the data such as expected pmt dates and amounts. I am wanting to develop a report with all borrowers that have expected pmt dates coming soon.
It would be like
Borrower1 - pmt date XXX
Borrower2 - pmt date XXX
BorrowerX - pmt date XXX
I wont be able to generate a rpt if the temp qry only keeps the data temporarily. It does not save the data. I have heard that saving the data is not a good idea but if I am wanting to develop a report with expected pmt dates then I would think it would be necessary to save the data.
What do some of the experts think about this?