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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query in a Subform with Sums 9
Multiple Query questions 2
Creating a query that will search for first 3 letters of a postcod 2
RE: You tried to execute a query that does not include the specified e 0
Ranking based on Multiple Data Fields 10
How create ranking within subgroup 4
Split data in field on character return 0
Query criteria in a memo field 1

Back
Top