Report record order

D

David Widener

I have a 3 record per page report that has a table as the record source but
when I look through the report all the records are not in the same order as
they are in the table, there is no sorting or grouping on the report or the
table, it starts off right but loses its sort after about 35 records through,
does anyone have any ideas ???
 
C

cherman

Off the top of my head, you can either set the sorting by opening the table,
sorting it the way you want and then saving it. Or you can add sorting to the
report, which is what I would suggest. I’ve never relied on the way the table
shows records, as I think it shows as they are entered in, but I imagine
there are many ways for this to get messed up.

HTH,
Clint Herman
 
F

fredg

I have a 3 record per page report that has a table as the record source but
when I look through the report all the records are not in the same order as
they are in the table, there is no sorting or grouping on the report or the
table, it starts off right but loses its sort after about 35 records through,
does anyone have any ideas ???
Click to expand...

Any sort order in the table (or query if a query is the report's
record source) is irrelevant in a report.
Set the report's sort order in the Sorting and Grouping dialog.
In report Design View...
View + Sorting and grouping.
 
Top