Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Rotation

0 views
Skip to first unread message

Mike Brownlie

unread,
Apr 8, 2002, 3:54:05 AM4/8/02
to
I need to put my drivers rota in to a database (250 of
them) the current rota is in 123.

this is what i need the database to do.

Wk 1
Driver No Driver Name
1 Andy Roberts
2 Billy Andrews
3 John McInnon

Rotate

Wk2
Driver No Driver Name
1 John McInnon
2 Andy Roberts
3 Billy Andrews

Wk3
Driver No Driver Name
1 Billy Andrews
2 John McInnon
3 Andy Roberts

and so on....

The driver number does not change ie the top driver is no
1 and the bottom driver is no 250.

(the actual rota stays the same)

If anyone has any input please drop me an e-mail or reply
to this posting.

Thanks in advance

Mike Brownlie

Michel Walsh

unread,
Apr 8, 2002, 7:27:50 AM4/8/02
to
Hi,

apply

Updated DriverNo = 1 + (DriverNo MOD 3)

in succession to get a new "cyclical shift" each time.


Hoping it may help,
Vanderghast, Access MVP

"Mike Brownlie" <mad...@michaelbrownlie.fnet.co.uk> wrote in message
news:503701c1ded2$8e1e1880$3def2ecf@TKMSFTNGXA14...

Mike Brownlie

unread,
Apr 8, 2002, 8:03:33 AM4/8/02
to
where and how??
>.
>

Michel Walsh

unread,
Apr 8, 2002, 3:01:29 PM4/8/02
to
Hi,


In an update query. Make a backup first, then, update DriverNo to:

1+([DriverNo] Mod 3)

Run the query once a week (each time you want to make a new "shift")


Vanderghast, Access MVP

JOSEPHDubio

unread,
Apr 9, 2002, 5:38:11 AM4/9/02
to

"Mike Brownlie" <mad...@michaelbrownlie.fnet.co.uk> wrote in message
news:503701c1ded2$8e1e1880$3def2ecf@TKMSFTNGXA14...

Michel Walsh

unread,
Apr 8, 2002, 5:10:09 PM4/8/02
to
Hi,


Note that it may not work , with Jet, if you have a UNIQUE index/constraint on DriverNo, since when
1 will try to become a 2, there is already a two, the update fails.


Vanderghast, Access MVP

"Michel Walsh" <Vande...@msn.com> wrote in message news:#uqY#9y3BHA.2260@tkmsftngp02...

0 new messages