A Student Wrote:
>Hello-I have a quick question on this report.
>I can not figure out, for the life of me, how to format the report
>without repeating certain categories. For example, when I made my report
>from the wizard, the category column contained two furniture and two
>glassware. How do I get rid of these second ones?
>Also, How do I space these rows further apart?
>I hope these questions made sense, I am really confused.
>Thanks,

In short you want to group on Category and place the item that prints the label in the header for the category.

Here is more detail...

To group on category you have two options. You can create the grouping with the report wizard or you can create the grouping in design view after you have created the report.

Option 1, creating a grouping with the report wizard

  1. Start the process to create a new report from the query Inventory with the report wizard.
  2. When it asks, "Do you want to add any grouping levels?" select "Category" and click '>' to add a grouping level for the field category.
  3. Finish answering the questions from the report wizard to create the report.

Option 2, creating a grouping in deign view

This method is a bit harder but achieves the same result.

  1. [Start with the situation you described above: you have a report that repeats the category label for each record.]
  2. Open the report in design view.
  3. Select the menu option View/Sorting and Grouping
  4. Use the pull-down to select Category
  5. Under Group Header select "Yes"
  6. Close the sorting and grouping dialog box
  7. Back at the report in design view select the Category label
  8. Select Edit/Cut to remove the label from the Detail section
  9. Select the section "Category Header" and then select the menu command Edit/Paste
  10. Now switch back to the regular view and you should see only one label for each category

To space rows further apart open the report in design view and make the Detail section of the report taller. To do this:

  1. Move the cursor to the bottom edge of the section until it changes into a horizontal line with two arrows.
  2. Click and drag the section divider down

Eddie