I am trying to take data which is in text format and manipulate it before a report is generated, but i can not seem to get this to work.
for example, i have a field called "para_num" and i want to (for example) add a 1 to para_num before the report shows me the data.
so, if i have 24 paragraph numbers, each should (using VBA code) be incremented by 1 before the report is shown.
now, do i place the module in the query or in the report for this to happen? Also, writing the code has been a hassle and has not worked yet...interfacing with the data before the report gets it has baffled me thus far.