I have a MS Access Database that tracks clients, client regions and transaction types.
Users are keying in transactions and once done, the system needs to create letters to the client regions headquarters sorted by
Client Region (Region A, B etc) AND Transaction Type(TransType 1, TransType 2) eg.Region A:TransType 1, Region B:TransType 1, Region A:TransType 2.
I am working with VBA, SQL statements (ran through VBA), Word OLE Automation, ADODB Recordsets and Unique strings.
Could anyone advise on how I can structure my DB to track the Letters and all the details about the letters?