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 ?
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" wrote: > 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 ?
Bob Thanks heaps ! Sorted the report and back on line. Cheers Alex "boblarson" wrote: > 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" wrote: > > > 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 ?
On Sun, 6 Jul 2008 13:45:01 -0700, Alex wrote: >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. -- John W. Vinson [MVP]
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) "Alex" wrote in message news:5ADFF1B0-6E44-4401-8A09-58D343171FB5@microsoft.com... > 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 ?
