Alphabet order

[Chi Huynh]

Hi,

Example: I have a table which has three fields (ID,AMOUNT
and PRODUCT. For PRODUCT field ,I choose field type is a
look up wizard. Therefore in datasheet view , PRODUCT
column has a drop down list. However,the list always
sorted A-z or Z-A.
(Car,Chair,....Iron, ....Spoon ..Zipper, ). What should I
do if I want the list not follow by alphabet order?
Thank you
Chi Huynh

 

[AJ Raiber]

Huynh,

What order do you want the products to show up in?
Is there a field in the table you are pulling from that
will put them in that order?

 

[John Vinson]

Hi,

Example: I have a table which has three fields (ID,AMOUNT
and PRODUCT. For PRODUCT field ,I choose field type is a
look up wizard. Therefore in datasheet view , PRODUCT
column has a drop down list. However,the list always
sorted A-z or Z-A.
(Car,Chair,....Iron, ....Spoon ..Zipper, ). What should I
do if I want the list not follow by alphabet order?
Thank you
Chi Huynh

You should create a Query sorting the table in whatever order you
want; you must have a field in the table to define that order.

Note that table datasheets are VERY limited in their capability, and
most developers recommend a) using Forms for all user interaction,
with tools like combo boxes; and b) avoiding the "Lookup Wizard". It
can be very confusing to new users of Access. See
http://www.mvps.org/access/lookupfields.html for a discussion.