Access Question

[Guest TheGame2705]

I made a database of stuff in my EWR game and wanted to know if I could do a filter/sort or whatever by their rank on the card (main event, midcard, jobber, etc.). Like if it'd be possible to only see a certain rank or see the rank in the order I choose. Anyone get what I'm saying. Thanks in advance if you can help.

[Guest areacode212]

In Table view, you should see an A-->Z icon on the toolbar. That sorts the table by the column you're in. There should also be an icon with the picture of a funnel on it. That filters the table using whatever's highlighted (e.g, highlight "midcarder", then click the icon).

[Guest TheGame2705]

Ok thanks for the filter help....but is there anyway to sort it by Main Event, Upper Mid, Mid, etc.? I know u can do it alphabetically but that makes Midcarder above Main event.

[Guest areacode212]

What I would do is create a separate table for the ranks on the card, and assign each one a number, like so:

0     Main Eventer
1     Upper Midcarder
2     Midcarder
3     Jobber to the stars
.
.
.

 

Make the number field the primary key, and call the table Rank Table or something.

 

Then, in the table with your wrestlers, go into Design View, and change the data type for the Rank info from "Text" to "Lookup Wizard", and make it read the values from Rank Table (just use the text column, not the number column).

 

Then, if you ever want to look at the sorted info, create a query, add all the relevant fields from the wrestler table, and both fields from Rank Table. Sort it by the Rank number, and hide the number column. That should do it.

 

It sounds like a lot of work, but it should only take a couple of minutes to do.

Edited March 3, 2003 by areacode212

[Guest TheGame2705]

hmmm thanks I'll try that out later