Hey All,
I'm new to reports and I am trying to wrap my head around designing a report. I am currently able to export data in the form I truly want using VBA to control MS Word. However, the users wants the ability to see the report from a form within the Access Database. The word document I export takes the form of a bulleted list. I was having problems replicating the same organization using a report. From what I've seen so far, a report adds rows of information consecutively until it reaches the end of the record source query. I can query the information just fine, but arranging a report in an intelligent manner is escaping me...
The form I'm after resembles: (NOTE: underscores were added because the post would delete spaces, _ = a space)
Header 1
___- Info 1.1
___- Info 1.2
______- SubInfo 1.2.1
______- SubInfo 1.2.2
___- Info 1.3
___SubHeader 1.1
______- Info 1.1.1
______- Info 1.1.2
______- Info 1.1.3
_________-SubInfo 1.1.3.1
_________-SubInfo 1.1.3.2
Header 2
___SubHeader 2.1
______- Info 2.1.1