Adding customers in alaphbetical order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Natasha

You can't. You may have a new customer (Mr Smith) today and add him to your
DB and in the morning you may get another new customer (Mr Jones) and add him
to the DB.

You can view the details in a query and sort the query by the surname and
first name so that Mr John Smith will be above Mr Wayne Smith (who will be
above Mr Mike Smith.

Hope this helps
 
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.
 
ooops - sorry

Wayne Smith would not be above Mike Smith if the surname "and" the firstname
were sorted.

Need more coffee
 
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.
 
Thanks for that guys
Enjoy coffee / beer


David F Cox said:
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.
Click to expand...
 
Back
Top