Re: Order of Records in Header on a Main form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Apr 24, 11:41 am, KARL DEWEY <KARLDE...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
records display in ascending order (in the order entered, that is, from

first record entered to most recent record entered)?
Records do not maintain an order of entry.  They are stored in a table like
a 'barrel of bricks.'  You must order them by sorting on a field.



"zufie" wrote:
Hi,

I cannot understand why the order of records displayed in the Form
Header on a Main form display in descending order (that is from most
recently entered to first entered record).

Is there a way via the Main form properties to change this so that
the
records display in ascending order (in the order entered, that is,
from first record entered to most recent record entered)?

These records are entered on a separate Subform (FrmGranteeEntry) and
display on FrmGranteeEntry in the order entered.

Any ideas?

Thanks!

John- Hide quoted text -

- Show quoted text -

Thanks Karl.

I did try sorting the field Award in Ascending (A to Z) order AND I
did try sorting the entire MainID table in Ascending (A to Z) order
but I get the same result?!

John
.

Relevant Pages

  • RE: Help on sorting in reports
    ... Roomtype - group header yes / group footer no / sort order ascending ... With above setting the report outputs as shown in the first paragraph below. ... Lowest price would be evaluated by the lowest half-twin rate in the first ... The desired output / sorting is shown at the bottom of my enquiry: ...
    (microsoft.public.access.forms)
  • Re: Random Number (not repeating a number)
    ... You bring up a very valid point Myrna. ... requiring sorting, the user controls when a new list is produced. ... enter this array formula where you wish to *start* displaying the ... >This will now give you a display of your 1 to 20 numbers, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: sorting question
    ... report's Sorting and Grouping to sort the report's records. ... primary key and therefore automatically sorts ascending. ... by all other ID's in ascending order which is not exactly what I'd ... The sorting issue still needs to be addressed. ...
    (microsoft.public.access.reports)
  • Re: Default sorting of Views
    ... John -- ... I have not discovered any way to change the display order of views on the ... The default sorting appears to be the default ... Enterprise Project Trainer/Consultant ...
    (microsoft.public.project.pro_and_server)
  • Re: Order of Records in Header on a Main form
    ... a 'barrel of bricks.' ... Header on a Main form display in descending order (that is from most ... did try sorting the entire MainID table in Ascending order ... I sorted the field, Date Last Updated, in Ascending order. ...
    (microsoft.public.access.queries)