Adding customers in alaphbetical order

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

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Natasha" wrote:

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

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" wrote in message
...
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

ooops - sorry

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

Need more coffee


--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Wayne-I-M" wrote:

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

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Natasha" wrote:

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

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" wrote in message
...
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" wrote in message
...
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

Oops! You're right, of course. blush

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


"David F Cox" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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

yep, coffee & beer


"Douglas J. Steele" wrote:

Oops! You're right, of course. blush

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


"David F Cox" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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

Thanks for that guys
Enjoy coffee / beer


"David F Cox" wrote:

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" wrote in message
...
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" wrote in message
...
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