I developed an Access database for one of our departments who uses it to create invoices, follow-up letters, and surveys for their clients. One pesky problem I am having is that when they use Word to mail-merge a selected client’s information into their standard follow-up form or survey, Word goes through a lengthy and repetitive counting/sorting process. (it will scroll through records starting at 1,2, etc… – frequently restarting at 1, and finally displaying the correct record. With usagegrowing, the time this process takes is getting longer, and many of those using the tool have taken to manually entering the information, which is less than desirable from my point of view. I thought having too few or too many indexes might be the problem, but altering the fields didnt have any discernable effect.
