Revolving list

[beau_daniel]

Hello,


Im new to access and was hoping to get some help. I have a database of 20 clients. I am trying to make a rotating list that will allow me to start with client # 1 and then click a button that will move that client at the bottom of the list (#20) and move everyone else up 1 (#2 will become #1, #3 will become #2, and so on). I dont even know where to begin. Please help.

[pbaldy]

If you include a "DateUpdated" field in that table, you could update it when you click the button (Date() or Now() function). An ascending sort in a query, form or report will display the oldest one first. Updating that one with the button effectively moves it to the bottom of the list, and moves the rest up. Failing that, you will need a field to hold the numbers (1 thru 20), and update all of them each time.