Sorting and grouping problem

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.
 
D

Duane Hookom

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.
 
P

PizzaBoy

Thank you for your response. In drafting a reply post I stumbled across my
answer.
 
Top