I have created an access form and have different fields on it. I want the report to print values according to a specific fields (i.e NBC & PPT#) and data related to these field. For example i have a textbox named NBC and other textbox are related to that field. If i gerented report based on these two fields the report prints each record on seperate line but i want the data to be printed according to NBC in single line. like this
NBC001...... PPT1
................ PPT2
................ PPT3
NBC002...... PPT56
................ PPT32
etc. Ho to do this ? kindly help
NBC001...... PPT1
................ PPT2
................ PPT3
NBC002...... PPT56
................ PPT32
etc. Ho to do this ? kindly help