Print report as entered in table

[Shane]

I have a report that is resorting the data from a table
but I have no sort or grouping criteria set, why??? I
can't use sorting and grouping because the data in the
table is in no particular and I want it to print in the
same order. Any help greatly appreciated.

 

[Tom Wickerath]

I can duplicate your observation, using the Northwind Employees table as the report's
recordsource, if I delete the primary key field. Does your table include a primary key
field? If not, try adding an autonumber field and setting it as the primary key.

Tom
____________________________________


I have a report that is resorting the data from a table
but I have no sort or grouping criteria set, why??? I
can't use sorting and grouping because the data in the
table is in no particular and I want it to print in the
same order. Any help greatly appreciated.

 

[Larry Linson]

By definition, records in a relational database table are unordered. If you
want some specific order, including the order in which they were entered,
you must provide a field/fields on which to order the data and use a query
whose SQL includes an ORDER BY clause.

Tom's suggestion of a PK may or may not work... generally, a table displayed
in datasheet view in Access will be shown in PK order, but _that isn't
guaranteed_.

Larry Linson
Microsoft Access MVP

 

[Tom Wickerath]

Larry,

I tested this out before sending my answer. I'm not sure why you say that it "may or may
not work". It certainly works this way in Access 2002.

Tom
_____________________________________

By definition, records in a relational database table are unordered. If you
want some specific order, including the order in which they were entered,
you must provide a field/fields on which to order the data and use a query
whose SQL includes an ORDER BY clause.

Tom's suggestion of a PK may or may not work... generally, a table displayed
in datasheet view in Access will be shown in PK order, but _that isn't
guaranteed_.

Larry Linson
Microsoft Access MVP