How do you figure a query when with a field within a field?

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

Guest

I am new to using Access. I have created a query with the following fields:
Unit Number, Bedrooms, Sleeps and Weekly Rate fields . I need to sort them
in descending order by bedrooms within sleeps. How do I do that?
 
Set the sort order for the "sleeps" to ascending or descending. Place the
"bedrooms" field to the right of that one and sort it.

Queries will sort on multiple columns starting from the left.

This can be done even more nicely (grouping) in a report or a form. I
typically use a query as my source for a report or a form. I rarely work on
data using a query.

Rick B
 
Back
Top