Discussion Locked

Access

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

7 replies

by choppit

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?

by alpha48

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.

Regards.

This discussion is closed to new replies.