Eliminating Sort on Specific Data in a Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a report that shows the following data:

Item ID Item Description Price Pack/Size Comment

Sorted by the follwing criteria:

Primary Category
Country
Subcategory

The report works fine, but my problem is that when an item is not assigned a
subcategory (not mandatory) the report shows is a blank space under the
Country segment because Access actually reads the unassigned field as a
actual subcategory. Is there any way to tell access that if there is no
subcategory assigned to exclude the grouping on those item(s)?

My simple solution is just to assign all similar items into a "catch all"
subcategory, but I would rather avoid that if possible.



The report works fine except for on
 
The items where Subcategory is null will form a grouping of their own.

You could eliminate the blank space by setting the CanShrink property to Yes
for the Subcategory text box, and also for its Section (a Subcategory group
header?)

Alternatively, you can create the catch-all subcat by setting the Control
Source of the text box to something like this:
=Nz([Subcategory],"{Unassigned}")
Be sure to change the Name of the text box as well: Access gets confused if
the control has the same Name as a field, but is bound to somehing else.
 
Back
Top