Sorting and grouping problem

  • Thread starter Thread starter PizzaBoy
  • Start date Start date
P

PizzaBoy

I have a report with two groups-building and bedrooms. Building comes first
in the group list followed by bedrooms. On the report I only show summary
fields in the footer for bedroom. I would like the report to sort by
building first and then the number of bedrooms. Currently the report appears
to maybe sort by bedrooms but not in a consistent manner. Thanks for any
help.
 
You must have a value in the report's recordsource if you want to sort by
it. Would you mind providing some sample records and how you would expect to
see them displayed in your report?

I suspect you can create a totals query that counts bedrooms by building and
includes this query in the report's record source.
 
Back
Top