Multiple Orders on same letter - Microsoft Access Expert 6


	Back to Access Expert 6 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multiple Orders on same letter

Barbara Learned

2 years ago

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.

	Richard Rost @Reply 2 years ago
Can you show me a sample of what you mean?

	Barbara Learned OP @Reply 2 years ago

	Barbara Learned OP @Reply 2 years ago
This is the report...

	Richard Rost @Reply 2 years ago
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 Learned OP @Reply 2 years ago
Great! I'll look for it in the lessons, you wouldn't happen to remember which lessons, would you? Thanks!

	Richard Rost @Reply 2 years ago
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.

	Richard Rost @Reply 2 years ago
Billing Statements

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 6.

Next Unseen

New Feature: Comment Live View