Under "Sorting and Grouping" I have entered that I would like the report to be alphabetized by "Supplier" and then by "Product Name." And when I run the report it works, it looks great . . . on the first page. However, on the second page (and it is only two pages long) it is no longer alphabetized. In fact, a supplier that starts with the letter "B" is not even on the first page. Any ideas?

Okay, I've made a little progress in understanding why the suppliers are not listed in alphabetical order on the report. These suppliers come from a table that is autonumbered. They are not in alphabetical order on that table, they are in autonumber-order -- which is the same thing as saying they are in the same order in which they were entered.

Hence, when I tell the report to put the suppliers in order, it is organizing them according to the autonumber order on the "Supplier" table. I guess this is what happens when you let Access make the autonumber field the primary key. Am I stuck with this, or is there still some way to get the report to alphabetize?

If based on a query, I perform my sorting in the query and not worry about it in the reports. If on a table, then you will need to ensure you are sorting on the suppliers name and not the autonumbering field.

If sorting on one or more fields, the order of the sort will be critical. For instance, sorting in the query, the supplier name column must be before the the product name column (both sorted A to Z) to achieve your desire.

For a report based on a table, I am unsure now because I am using '07 exclusively and haven't ran into that issue yet.

-dK

You should be able to group/sort by supplier name rather than supplier ID.

Yup. I guess I just had to tweak my query. Thanks guys!