Re: Ascending Combobox pulling from table field

Tech-Archive recommends: Fix windows errors by optimizing your registry



>Create a query that sorts the data in the desired order, and use the query
>as the RowSource instead.

I thought maybe I could get around creating another query, but I used the
above method and all is good. Thanks.

-Charles-

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200512/1
.



Relevant Pages

  • Re: Differences in Range Scan Performance between Binary and NLS Indexes
    ... And our query plan looks like this and completes in about 120 ms. ... 400 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
  • Re: Sort Multi Time Fields
    ... <MS ACCESS MVP> ... When it sorts now, it sorts numerically (ex: ... I do have the report sorting and grouping by date ... Save the query. ...
    (microsoft.public.access.reports)
  • Re: How do I sort a table...
    ... Create a query that sorts the data in the desired order. ... Public Sub test() ...
    (microsoft.public.access.modulesdaovba)
  • Re: Class reunion query
    ... (no private e-mails, please) ... This query worked, almost. ... It sorts by the first name and not the LastName/as I had ... FROM tblDemographics ...
    (microsoft.public.access.queries)
  • RE: date format/sort problem
    ... There is no such thing as a Date/Time data type which only contains ... The Format propety of the field determines how the data in the field is ... In my first query I need to format it: ... This works fine and the query sorts in chronological order however when I ...
    (microsoft.public.access.queries)