General discussion

Locked

Access

By john.cb1 ·
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.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by john.a.wills In reply to Access

There is no order in a relational DB table. Arrange your ordering in your SELECT statements.

Collapse -

by john.cb1 In reply to

Poster rated this answer.

Collapse -

by Choppit In reply to Access

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?

Collapse -

by john.cb1 In reply to

Poster rated this answer.

Collapse -

by Alpha48 In reply to Access

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.

Collapse -

by john.cb1 In reply to

Poster rated this answer.

Collapse -

by john.cb1 In reply to Access

This question was closed by the author

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums