Report using letters for query results

[hawkdriver]

Normally, I can find answers to my complex problems or figure them out on my own. I hope I can explain my situation well enough.



I am creating a database that records weekly updates from different division managers. This will be output as a Word document in the following format:

1. Priorities

a. Long Text field output
b. Long Text field output
c. etc.

2. Issues/Concerns

a. Long Text field output
b. Long Text field output
c. etc

3. Etc.

The grouped headings and outputting the text is not a problem, just having issues with the sub-text using little "a", "b", so on. The report is formatted currently as I show above. Rich text in Access is really not so rich (kind of like me .

Just looking for some ideas, as mine are inside the box right now. I thought about a running total field and convert that number to text. Any ideas or experience with this would be gladly welcomed.

[June7]

So you want an outline structure. Since Access is not a word processor, I doubt this will be simple. Possible solution:

The ASCII codes for a-z are 97-122. Use RunningSum calc in textbox (can be hidden) then in another textbox calculate the alpha: =Chr([firsttextbox]+96) & "."

[hawkdriver]

Nothing about this database has been simple - too much VBA. I am looking up outline structures, as this will be a first for me in Access. Thanks June. I will get back with you if I get this figured out.

[Collin]

The grouped headings and outputting the text is not a problem, just having issues with the sub-text using little "a", "b", so on. The report is formatted currently as I show above. Rich text in Access is really not so rich (kind of like me .



NAT