Access Printing Report

[MarkM]

I created a report that lists the data for example 1,2,3 when i go to print
this report the data prints in the reverse order 3,2,1. How do I correct
this problem?

 

[Larry Linson]

I created a report that lists the data for example
1,2,3 when i go to print this report the data prints
in the reverse order 3,2,1. How do I correct
this problem?

First you will need to clarify what you mean... perhaps someone here can
follow and understand, but I can't.

How about starting with: what version of Microsoft Access are you using?
What do you mean "lists the data for example 1,2,3" and what you do mean
"when I go to print this report the data prints in the reverse order 3,2,1".
On the other hand, if all you mean is that you see page 1 of the report in
on-screen preview but when it prints it stacks the sheets in reverse order,
that's a matter of the control functions of your printer.

Well, that'll be a start.

Larry Linson
Microsoft Office Access MVP

 

[Marshall Barton]

I created a report that lists the data for example 1,2,3 when i go to print
this report the data prints in the reverse order 3,2,1. How do I correct
this problem?

Sorting in a report should be done using the report's
Sorting and Grouping window (View menu).

Sorting in a report's record source query is a waste of time
in all but the most trivial reports.

 

[MarkM]

In following your advice and getting more specific with my problem so I could
post a more intelligent question I found the problem. In the forms subform
“property sheet†under “order by†it was sorting the subform; so whatever I
typed in was re-sorted in the reverse manner it was entered. Thank for help!

 

[Larry Linson]

Worth bearing in mind: the order in which records appear in a Report is
completely independent of the order in which they occur in the RecordSource
of the Report (or, for that matter the order in which they appear in any
other object) -- in a Report, the order and grouping of records is
controlled by the Report's Sorting and Grouping properties.

Click on the upper-left-most little square in Design View of the Report,
then right-click and choose "Sorting and Grouping" from the popup menu, and
specify the order.

Had you had this in mind, you probably wouldn't have expected the order to
be the same in the Subform and in the Report.

Larry Linson
Microsoft Office Access MVP