Behaviour of a report

[stevens]

I don't know if there is anything I can do about this, as it may be a quirk
of Access but here goes. I have a table in which I have carefully massaged
and placed data using VBA making sure that it was in proper order and
grouping. I want to create a report from this table just as it is, but when
I bring up the data in the report, it doesn't maintain the proper order,
although it maintains the proper grouping. A query will do me no good. Is
there any way to force the report to read and display the data in exactly
the same order, record for record, as is in the table? I guess I could put
another field in the table that numbers the items within the groups and sort
on that field in the report, but I wanted to see if there was another way to
do this and make the report behave and show the data like it is in the
table. thanks
SteveS

 

[fredg]

I don't know if there is anything I can do about this, as it may be a quirk
of Access but here goes. I have a table in which I have carefully massaged
and placed data using VBA making sure that it was in proper order and
grouping. I want to create a report from this table just as it is, but when
I bring up the data in the report, it doesn't maintain the proper order,
although it maintains the proper grouping. A query will do me no good. Is
there any way to force the report to read and display the data in exactly
the same order, record for record, as is in the table? I guess I could put
another field in the table that numbers the items within the groups and sort
on that field in the report, but I wanted to see if there was another way to
do this and make the report behave and show the data like it is in the
table. thanks
SteveS

Reliable report sorting can only be accomplished through the report's
Sorting and Grouping dialog.
In Report Design View click
View + Sorting and Grouping

If you have a particular need to sort records according to the order
they have been entered, add a date datatype field to the table, and
set it to enter the date and time when the record is created (Default
Value =Now())
Then use this field as the top level of sort order in the sorting and
grouping dialog.

 

[Douglas J. Steele]

The only way to control the order of records in a report is to use the
Sorting and Grouping dialog within the report.

For that matter, though, you should never assume anything about the order of
data in a table: just because you think you've inserted the rows in a
specific order does NOT mean that they're actually in the table in that
order.

If the order's important, you must include something that you can sort on
when retrieving the data.