RonMcIntire
Technical User
PURPOSE
My goal is to print a directory listing containing the chapter organization name and address and 21 chapter officers with name, address, phone and email on one page of a report for each of 61 chapters. All the data is in one large record including the chapter name and address.
DATA STRUCTURE & APPROACH
I have created the printed record by filtering the appropriate officers (Pres, VP, Sec, Treas, etc.) from one table into 21 separate queries then concatinated those queries and the Chapter information is into one large query. The relationship is created solely in the queries.
PROBLEM
The record apparently exceeds the 2000 character limit of Access 97 yielding the error message "Record is too large".
POSSIBLE SOLUTIONS:
1. i can strip out the organization name and address data but I must print it with the list of chapter officers. The problem is, I do not know how to print a information that has a relationship to a record but is not included in the record.
2. I can cut the list down to 17 or 18 officers but it would limit my directory to some extent.
Is there a simpler way of printing a "record" larger than 2000 characters in A97?
Ron
My goal is to print a directory listing containing the chapter organization name and address and 21 chapter officers with name, address, phone and email on one page of a report for each of 61 chapters. All the data is in one large record including the chapter name and address.
DATA STRUCTURE & APPROACH
I have created the printed record by filtering the appropriate officers (Pres, VP, Sec, Treas, etc.) from one table into 21 separate queries then concatinated those queries and the Chapter information is into one large query. The relationship is created solely in the queries.
PROBLEM
The record apparently exceeds the 2000 character limit of Access 97 yielding the error message "Record is too large".
POSSIBLE SOLUTIONS:
1. i can strip out the organization name and address data but I must print it with the list of chapter officers. The problem is, I do not know how to print a information that has a relationship to a record but is not included in the record.
2. I can cut the list down to 17 or 18 officers but it would limit my directory to some extent.
Is there a simpler way of printing a "record" larger than 2000 characters in A97?
Ron