I am new to reports. I am trying to create a report that groups items by their item no. I first run a query that searches items by BETWEEN [BEG NO] AND [END NO]. Then I want to group by item numbers with their listed descriptions. Here is an example: I would query for a beginning item number that is "1765T100A" and an ending number that is "1765T301". 1765T will always hold that same basic format but the ending values are arranged as 100A, 100B, 100C, 200, 201, 201A, 201B, 300, 300A, 301, etc.. I can't figure out how to group 1765T100A, 1765T100B, 1765T100C on new pages. I hope that someone will be able to make some sense out of this jibberish. Thanks in advance for all the help.
jstew
jstew