I am creating a DVD database in Microsoft Access. I have column called Dvd Title. I am sorting these out in alphbetical order.
I want to put a ID such as a DVD number in another column. How can i do this so that the dvd titles stay in alphbetical order and the dvd numbers stay in numerical order
This conversation is currently closed to new comments.
The whole point of using a relational database is that the data does not need to stored in order. The data can be filtered and manipulated for the user via queries. Is access the right choice for your needs?
If your database has already been started, go to the table [in design view] and add another line to it called ID# after hitting enter, use the drop down the box to select number, further down the screen decide on the format of the number. My favorite usually allows decimals, in order to accomodate similiar items. Frank Sinatra the 1940's-->1.00, Frank Sinatra the 1950's-->1.01; therefore, any number of his DVD's are available sorting on the criteria of less than 2 or <2. If you use a form to enter the DVD data just go to it's desing view and add the new ID# field.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access
I want to put a ID such as a DVD number in another column. How can i do this so that the dvd titles stay in alphbetical order and the dvd numbers stay in numerical order