View Single Post
  #1  
Old May 29th, 2006, 05:50 PM posted to microsoft.public.access.tablesdbdesign
external usenet poster
 
Posts: n/a
Default Adding a new record in alpha with an exception

Does anyone know if this is possible:

I want to create a form that will add a new record to a table that has only
one field, eg category; and I want these to be listed alpahabetical.
However, there are four categories that I always want to be at the bottom of
the list, irrespective of where they fall alphabetically, eg

Books (alphabetical)
DVDs (alphabetical)
Films (alphabetical)
Plays (alphabetical)
Family DVDs (not alphabetical - at bottom of choose list)
Family films (not alphabetical - at bottom of choose list)

I've been playing around with this for ages but can't find a way to do what
I want to. Does anyone have any ideas?

Many thanks
Aehan