D
D. M.
Hello,
I created a lease management database to house lease/rent payment
information for over 200 stores. Every month, we have to print a rent
remittance report to send with each rent payment.
I created the report based on a parameter query. The remittance shows a
breakdown of the payment, and, if we pay percentage rent for a location, we
need to show the monthly sales for the current year. Here's the problem: We
need to show the sales for the lease year (if a lease was signed June 1st, we
need to show sales for June through May of the current year). The parameter
query solves this problem.
What I need to figure out is, can we somehow batch print the reports? The
criteria is:
1) is there percentage rent, if yes, show sales
2) look at lease start date and determine lease year months
3) print ALL reports
Can this be done (I have NO experience with code)?
Any help would be appreciated. Thanks in advance.
I created a lease management database to house lease/rent payment
information for over 200 stores. Every month, we have to print a rent
remittance report to send with each rent payment.
I created the report based on a parameter query. The remittance shows a
breakdown of the payment, and, if we pay percentage rent for a location, we
need to show the monthly sales for the current year. Here's the problem: We
need to show the sales for the lease year (if a lease was signed June 1st, we
need to show sales for June through May of the current year). The parameter
query solves this problem.
What I need to figure out is, can we somehow batch print the reports? The
criteria is:
1) is there percentage rent, if yes, show sales
2) look at lease start date and determine lease year months
3) print ALL reports
Can this be done (I have NO experience with code)?
Any help would be appreciated. Thanks in advance.