ideas on how to do this

[icemonster]

ok.

so what i want to do is, put a ranking on a record which i already did, and have done already.

what i want is to be able to rearrange the ranking, what's the best way to do this? do i use a field? a calculated expression?

to elaborate, let's say i have 10 records, from 1 to 10, if the user wishes to rearrange the order of the record say, wants 7 to be 1, what's the best way in doing this while having the query or code re rank the records accordingly?

 

[the_net_2.0]

first, check this out:

http://www.access-programmers.co.uk/forums/showthread.php?t=157748&highlight=randomize

That is the concept to use. Some places on the net will do it with other entities in code, but arrays you can do it with as well. You can also google for 'random record' and use the codes you find to implement this. Randomization code won't get you the whole thing, but you can use part of any code you find I'm sure.

 

[icemonster]

thanks, i'll check it out. lol on the user though, banned

 

[the_net_2.0]

thanks, i'll check it out. lol on the user though, banned

that's me, my friend

 

[icemonster]

ahaha. lol. i didn't realize it. thanks for pointing me to the right direction. just that, it was bad enough they wanted it ranked, now they way to be able to change the rank as they please it. just never had any idea nor tackled that kind of request before.