Records won't group

  • Thread starter Thread starter J
  • Start date Start date
J

J

I have a group of records that will not group at all. I went into
sorting and grouping and specified what I want the records to be
grouped by. When I run the report all the records are entered
individually. Would this occur if there was one character different
about each of the records? And if so, how could I get around this and
group the records. I don't know if this matters or not but the only
fields that I'm using in my report are the ones that records will have
in common the most except for a couple of instances. Any help is
appreciated.
 
By the sound of it you may have a misunderstanding about what grouping is
all about. Lets say you have product categories and product Ids. Multiple
products may fall into one category in a one to many relationship. If you
group on the category, and display a group header to show the category, then
those products that are related to that category will follow in the detail
section, followed by the next category header and related records.

Your post sounds like you are expecting "grouping" to sort of combine or sum
the values in the records in some way. If you wanted that to occur, you
could create a group footer and then use a Sum() on the fields in question
(e.g. inventory count). If you only wanted the sum, then don't put any
controls in the detail section.
 
All I need to do is be able to group records together so that the same
records are not constantly being shown in my report and taking up a lot
more space then what is needed.
 
Then open the query that underlies the report, open the query properties
dialog and set the "Unique Values" property to True
 
Back
Top