Help with programming Access 2003

[samurai71]

I am doing a database of my families movie collection and I would like
to have a feature like an autonumber for sorting the movies in their
cases. I have the movies broken up into A(dult) and K(id) I would
like to have the autonumber have either the a for adult or k for kid
then the number. However I have no idea on how to achieve this....Any
assistance would be greatly appreciated and thank you in advance for
your help

 

[Minton M]

I am doing a database of my families movie collection and I would like
to have a feature like an autonumber for sorting the movies in their
cases. I have the movies broken up into A(dult) and K(id) I would
like to have the autonumber have either the a for adult or k for kid
then the number. However I have no idea on how to achieve this....Any
assistance would be greatly appreciated and thank you in advance for
your help

You can't change the way the autonumber field works, but then why not
use the first character from the adult/kid field and prefix it to the
autonumber field using a query? Let me know if you need more details.

-- James

 

[samurai71]

You can't change the way the autonumber field works, but then why not
use the first character from the adult/kid field and prefix it to the
autonumber field using a query? Let me know if you need more details.

-- James

I am not following you can you be more detailed please!!

Mark

 

[John W. Vinson]

I am doing a database of my families movie collection and I would like
to have a feature like an autonumber for sorting the movies in their
cases. I have the movies broken up into A(dult) and K(id) I would
like to have the autonumber have either the a for adult or k for kid
then the number. However I have no idea on how to achieve this....Any
assistance would be greatly appreciated and thank you in advance for
your help

This is A Bad Idea.

Each field should be "atomic" - having one and only one value.
Autonumbers cannot contain text.
Your ID number should be just an ID number; the adult/kid attribute of a movie
is data, which should be in a separate field, not in the ID. You can use a
Query to select only adult movies, or only kid movies, or you can sort by the
adult/kid field to list the movies separately - but there is no benefit to
trying to jam the two disparate pieces of information into one field.

John W. Vinson [MVP]