Access 2003 Reports all jumbled order

[Alex]

HELP ! Under Access 2003 we have a table for keepig track of our orders.
These are Auto Numbered and sorted as a date entry ie/ latest order last.
Every time you open the table it is always in the correct order form earliest
date the most recent date. When we did a report (based on this table) it used
to print all the pages in the report in the same order as the orders were
placed in the table. In the last week it is now printing the pages in the
report in a random order. If we add new lines to the table, in the report it
just places them anywhere and we have to search through the whole report to
find them. Any Thoughts ?

 

[boblarson]

Alex:

A couple of things for you:

1. Autonumbers are not guaranteed to be in consecutive order, just unique.

2. Reports should have a sort order assigned in the Sorting and Grouping,
because it will not carry over sorts from tables (if tables were sorted,
which they are not) or queries.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Alex]

Bob

Thanks heaps ! Sorted the report and back on line.

Cheers

Alex

 

[John W. Vinson]

HELP ! Under Access 2003 we have a table for keepig track of our orders.
These are Auto Numbered and sorted as a date entry ie/ latest order last.
Every time you open the table it is always in the correct order form earliest
date the most recent date. When we did a report (based on this table) it used
to print all the pages in the report in the same order as the orders were
placed in the table. In the last week it is now printing the pages in the
report in a random order. If we add new lines to the table, in the report it
just places them anywhere and we have to search through the whole report to
find them. Any Thoughts ?

A table HAS no order. It should be viewed as a sack full of data; there isn't
a "first record" or "last record" in a table in any useful way, any more than
there's a "first potato" and "last potato" in a sack of potatoes.

In order to see records in a Report in a particular order, open the report in
design view; right mouseclick on the little square at the upper left
intersection of the rulers, and choose "Sorting and Grouping". Select the
field or fields that you want to specify the sort order and select Ascending
or Descending as appropriate. If your table does not contain fields which let
you specify the order, you'll need to add such fields.

 

[david]

You probably need to check your autonumber values, to see that you
haven't accidently reset the autonumber, because you will have problems
if the numbers collide.

Another thing that might have caused you to notice the problem is if
you did a compact or repair to the data. Compacting re-sorts the data
from order of entry to order of primary key. This sort order normally
comes through to the forms and reports, but of course it is a bad thing
to depend on it (and for complex queries and reports you can't depend
on the table sort order anyway).

What you see when you open the table doesn't mean anything, because
there is a display property for tables which can sort the table. If you
save that view of the table, you will always see a sorted view, just like
your report gives you a sorted view now that you have corrected the
sort order property.

(david)

 

[a a r o n . k e m p f]

bull shit you fucking newbie

if your database can't reliably put out incrementing numbers-- then
move to an engine that can.

Seriously-

JET is stupid

move to SQL Server