Re: Reverse Order

From: Nikos Yannacopoulos (nyannacoREMOVETHISBIT_at_in.gr)
Date: 12/03/04 

Date: Fri, 3 Dec 2004 14:25:37 +0200

James,

Do you mean display the most recent dated records first? If yes:

If the form's recordsource is a query, then open the query in design view
and set the sorting on the date field to descending;

If the form's recordsource is directly the table, then open the form
indesign view, select the form object, display properties, and on the Data
tab set the Order By property to:
fldDateUsed DESC

HTH,
Nikos

"James" <James@discussions.microsoft.com> wrote in message
news:3CF951F4-C336-486B-87C3-34BC332DD29E@microsoft.com...
> How do you make a form display in reverse order by using the date field
> (fldDateUsed)?

Relevant Pages

  • How can I make a form re-read (refresh) its datasource
    ... seems to work except when I open the display form to display the data ... the display form with this new query as the recordsource. ... So, when I execute, if the form F2 is not open, the form opens and ...
    (comp.databases.ms-access)
  • Re: "Reading" user input
    ... Have the recordsource of the form as a ... In the Criteria of the relevant fields in the query, ... Joe wrote: ... > display a set of records from a table. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: LIST BOX ISSUES
    ... Easiest approach is to have the recordsource of your list box contain all of ... base the list box on a query, say, that returns the ... even if you only display one field in the list box. ... > automatically in other boxes on the form. ...
    (microsoft.public.access.formscoding)
  • Re: "Object doesnt support this property or method"
    ... INNER JOIN ... Note that the query has been in production for a couple of ... that I also tried) display as expected. ... verified that "Title" is indeed defined by the form's RecordSource ...
    (microsoft.public.access.formscoding)
  • Re: DB Result Wizard Error
    ... Also noted that one folder, which contains no information can't be deleted, ... >> For instance Equipment Serial Number, Equipment Model Number, Cost Accounting ... >> to display the new equipment information. ... >> is in the table was added to the query. ...
    (microsoft.public.frontpage.programming)