Order records in a report

F

Frank Spadafora

I have a very simple report based on one table. I am trying to order the
records on two of the fields both in ascending order. To do this I placed the
names of the fields in the report Order By parameter and set the report Order
By On parameter to YES. This has no affect at all on the order that the
records are displayed.

Any suggestions would be appreciated.
 
M

Marshall Barton

Frank said:
I have a very simple report based on one table. I am trying to order the
records on two of the fields both in ascending order. To do this I placed the
names of the fields in the report Order By parameter and set the report Order
By On parameter to YES. This has no affect at all on the order that the
records are displayed.
Click to expand...


In all but the most trivial reports, you should use the
Sorting and Grouping window (View menu) to specify the
report's sort fields.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Weekly Report 2
Report sorting 1
How to display records in ascending order on a report 1
Problem with SET & REF function 0
Finding the right style field in VBA 0
Do I need different reports to change Sort Order? 2

Top