Re: Adding customers in alaphbetical order

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

I think more coffee is needed all round - and ORDER BY clause is used in a
query to sort records, the WHERE clause selects records that meet a
particular condition.



"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in message
news:efZtNc65GHA.4116@xxxxxxxxxxxxxxxxxxxxxxx
That's not how relational databases work. Tables are essentially unordered
sacks of data: what you add to the table gets put wherever Access thinks
is the best fit.

The only way to ensure that records are displayed in a particular order is
to create a query with an appropriate Where clause. You can then use the
query wherever you would otherwise have used the table.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Natasha" <Natasha@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C66CB118-F982-4F87-8221-C1CE8A943C4C@xxxxxxxxxxxxxxxx
I want to add new customers in alaphabetical order instead of the new
customers going to the end of the list. Is this possible.

Natasha





.

Relevant Pages

  • RE: Any good T-SQL quick reference recommended?
    ... The full syntax of the SELECT ... SELECT Clause ... Specifies the columns to be returned by the query. ... Specifies that duplicate rows can appear in the result set. ...
    (microsoft.public.sqlserver.programming)
  • Re: providing an any option within a combo box
    ... what was after the Or in the Where clause is invalid. ... Doug Steele, Microsoft Access MVP ... let's see the SQL for your query. ...
    (microsoft.public.access.gettingstarted)
  • RE: Xlocking with a select statement
    ... named query expression, order clause, update clause, lock option ... A result table or the underlying base tables are updateable if the query ... A lock can be requested for the ...
    (microsoft.public.sqlserver.programming)
  • Re: update query: still having problems
    ... "Michel Walsh" wrote: ... From the User Interface, in the toolbar, or the menu, when you edit a query, ... If this is what you want, fine, else, add a WHERE clause to limit ... SELECT Department.*, sheet1.* ...
    (microsoft.public.access.queries)
  • Re: update query: still having problems
    ... "Michel Walsh" wrote: ... you should find a button that allows you to change the query "type". ... If this is what you want, fine, else, add a WHERE clause to ... SELECT Department.*, sheet1.* ...
    (microsoft.public.access.queries)