Grouping

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I am trying to develop a report which groups on a unique number and then
subgroups on the addresses. Here is an example, a single address (street,
city, st, zip code) could have 5 unique numbers. I would like to group by the
full address including the name and show all 5 unique number below. Would
this be possible to do?

Thanks,
Mike
 
In the Sorting & Grouping window, select the address field (is it a single
field? or separate fields?
--

Ken Snell
<MS ACCESS MVP>

) as the first row, then select the unique number field as the second row.

If the address parts are in separate fields (which they should be), then use
an expression in the first row for the "field", where the expression
concatenates the address parts into a single string value.
 
Back
Top