You will need two fields. One call TopSort and make it a number field.
Default to 0. For those Family items use 1 in the field. In design view
click on menu VIEW - Indexes. Name the index MySort and add the number field
and then the category field.
In your queries always sort on the two fields.

"aehan" wrote:

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