I have a database for an organization that drops members after 2 years of non-payment. Is there a way to include 2 "orders" in the same letter. I know I can add the two orders together, but I would like to be able to list each year individually, as the amounts may be different. It currently prints a separate letter for each order. I want to be able to send a final notice letter, letting the member know they are about to be dropped, and loose their consecutive years.
This would be very much like a billing statement. Let's say you have customers on NET terms. They place orders throughout the month and you send them a statement once a month showing all their unpaid invoices it's almost exactly the same thing. I cover this in several lessons. Maybe I'll put together a quick TechHelp video on it too.
Barbara LearnedOP
@Reply 2 years ago
Great! I'll look for it in the lessons, you wouldn't happen to remember which lessons, would you?
Honestly, I cover this stuff in a lot of places... it's essentially a report with a grouping level. I'm working on a TechHelp video now. Should be ready by the end of the day. A few people have asked about different aspects of it, so I'll try to cover all the bases. Sit tight.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 6.
