Hi I'm new to this site so bare with me. I have a multi column report that I'm having a problem with. The report's recordsource is a query. In the query there is a number field [PositionStatus] that is use to determine if a record is an "Addition" or "Deletion". If the [PositionStatus] = 1 then the Item is an Addition or if the [PositionStatus] = 2 then the Item is a Deletion. What I want the report to do is reflect the Additions only on the left side of the report and the Deletions to appear on the right side. I have set the report to be a 2 column report and that doesn't work. One issue I have is that a report can have no Additions and several Deletions or I could have a couple of Additions and several pages of Deletions. Either way both Additions and Deletions, if applicable, must be side by side and no empty spaces, i.e., if there is a Deletion (right side) there is a blank space on the left side, etc. In other words I have to have 2 lists on my report side by side and at times each side row count may vary. I hope this makes since.
Thanks for the help, Sketti
Thanks for the help, Sketti