Report

T

TaylorLeigh

I have a table with 500 entries all in correct order. I have created a
query. All the table entries are there and in correct order. I created a
report and all the entries are there but there a few entries that have been
thrown out of order. What would cause this. I have checked everything I can
think of.
 
F

fredg

I have a table with 500 entries all in correct order. I have created a
query. All the table entries are there and in correct order. I created a
report and all the entries are there but there a few entries that have been
thrown out of order. What would cause this. I have checked everything I can
think of.
Click to expand...

The sort order of the table and of the query is irrelevant in a
report. If you wish to sort the records in the report you must use the
Report's Sorting and Grouping dialog.... in Report Design View click
on View + Sorting and Grouping.
 
L

Larry Linson

TaylorLeigh said:
I have a table with 500 entries all in correct order. I have created a
query. All the table entries are there and in correct order. I created a
report and all the entries are there but there a few entries that have
been
thrown out of order. What would cause this. I have checked everything I
can
think of.
Click to expand...

You are seeing the Table entries in whatever "default order" Access presents
them (and it must present them in _some_ order) but, by definition, data in
relational tables is "unordered". That is why you have the option to specify
sorting in Queries. Yet, even if you specify the sort order in a Query, it
will not necessarily (and probably will not) be shown in that order in a
Report.

That is because, by definition, order of presentation of data in a Report is
controlled by the Report's Sorting and Grouping properties. In design view
of the Report, click the upper-left-most little box, then right-click and
from the list choose Sorting and Grouping and specify your desired, er,
"sorting and grouping" in the dialog box that pops up. If you encounter
problems with and have additional questions about details in Sorting and
Grouping, post back here with specifics and someone will likely have a
useful suggestion for you.

Larry Linson
Microsoft Office Access MVP
 
Top