Forum Discussion
Key Field Question
I'm trying to create a database with a key field containing 1a, 1b, 2a, 2b, 2c, etc. If I make this a text field it does not sort properly. Is there a way to do this? Thanks for your help.
Define "sort properly", please.
Also, what is the goal here? When Access developers see the words "Key fields" we think of something very specific, so it may be that an appropriate answer would depend on why you are creating this field and what you plan to do with it.
I'm pretty much a novice when it comes to Access. I thought a key field is a unique identifier for a particular record in a table. I just want to be able to add cards to the table and have them be sorted in the right place.