Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » access training - Multiple sort criteria in a query

access training - Multiple sort criteria in a query

ResolvedVersion Standard

Mon 24 Sep 2007, 14:43 Delegate Paul said...

Paul has attended:
Access Intermediate course
Access Advanced course

Multiple sort criteria in a query

Hi All,

I need to sort a query by, first of all, part number then within the group in my report I want to sort by either the date due or the order number (smallest number = oldest date)

Any help?

Tue 9 Oct 2007, 16:30 Trainer Richard said...

RE: Multiple sort criteria in a query

Hi Paul,

Use the SORT field in the QUERY.

In the REPORT, use the SORT AND GROUP BUTTON, next to the TOOLBOX and FIELD LIST toolbar icons.
Simply add the field you want to sort by, and the way you want to sort.

Regards

Richard

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

access training - Multiple sort criteria in a query

Multiple sort criteria in a query

RE: Multiple sort criteria in a query

Access articles

Access tip:

Duplicating an Entry