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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
report

ResolvedVersion 2007

sofia has attended:
Word Intermediate course
Access Introduction course

Report

how would one sort data on a report

RE: report

Hi Sofia, Thank you for your post, in answer to your question;

Sorting Records on a Report;
1. Start Microsoft Access, and then open the database that you are working with.
2. Open the report in Design view.
3. On the View menu, click the Sorting and Grouping button to display the Sorting and Grouping dialog box.
4. In the first row of the Field/Expression column, select a field name or type an expression.
NOTE: When you fill in the Field/Expression column, Microsoft Access sets the sort order to Ascending.
5. You can sort on up to 10 fields or expressions in a report. To sort your report on more than one field, add another field or expression to the Field/Expression column. The field or expression in the first row is the first sorting level. The second row is the second sorting level, and so on. I hope that has helped, obviously this is for a report that has already been created, if you are creating a report from scratch, the sorting and grouping options are available in the Report Wizard, if it has helped, please click the Resolved link, best regards Pete

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.