Report record order

[Guest]

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 ???

 

[Joseph Meehan]

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
???

Tables don't have an order. They are more like a bucket full of data.
If you want an order you have to provide it. Spreadsheet like Excel have an
order but not databases.

 

[Guest]

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

 

[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 ???

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.