My Questions:
1. i have a database with 200 records and a rank field on the form. the user has the option to enter a rank for each record. I want to be able to produce a report that will generate the top "x number" of records selected by the user.
Because I have 200 records, i want the user to be able to select the number of ranks they want to see. for example if the database contained 100 records, i might want to see only the top 50, 60 or 70 records. This way the user always has the flexibility to choose how many records to see.
2) Also what if i later go in and delete a record ie. record 18, then record 18 is gone and the rank is also gone too so there's a missing gap. I need to make the database smart enough to fill in the gap.
There is a tutorial online. I have tried it and it does update but makes all the ranks number 1.
http://www.fontstuff.com/mailbag/qaccess02.htm Similarly i saw this on the site,
http://www.access-programmers.co.uk/forums/showthread.php?t=103456&highlight=rankExample:
TicketID PriorityID ManPriorityID
12345 1
12346 2
12347 3
I want to be able to add a number to ManPriorityID and have all the other numbers re-rank based on the Manual number entered.
Example:
TicketID PriorityID ManPriorityID
12345 1
12346 2 1 <--I enter this number
12347 3
Becomes:
TicketID PriorityID ManPriorityID
12346 1
12345 2
12347 3
Another Example:
TicketID PriorityID ManPriorityID
12345 1 3<--I enter this number
12346 2
12347 3 1 <--I enter this number
Becomes:
TicketID PriorityID ManPriorityID
12347 1
12346 2
12345 3__________________
--------------------------
----------
----------
----------
----------
---
more examples:
two values only: one is the current rank and another is the new rank
there can be three situations like this:
crank>nrank
crank=nrank
crank<nrank
Start Free Trial
