touch question - help if you can please

[Gary]

My question concerns a strategy for doing the following.

say you have four salesman.

Abba
Babba
Pato
Lopo

the first record added, will automatically have its salesman field set
to abba. The next record added as, babba is next in line to receive a
lead will have Babba entered as the salesman. Once Lopo has received a
lead, the next lead should be abba's ... ad infinitum.

Also i will need some way of 'skipping' over a salesman in case they
are at lunch, but then the next lead defaulting back to the usual
pattern.

Please help i don't have any idea how i might code this.

Thanks,

Gary.

 

[Gary]

Touch = Tough !

 

[Guest]

You need to record the datetime that each salesman do their thing. Use this
query and pick the one at the top of the list.
SELECT Table26.name AS [Up Next], Last(Table26.leadtime) AS [Last Time]
FROM Table26
GROUP BY Table26.name
ORDER BY Last(Table26.leadtime);

I do not know how you expect to skip the one at lunch unless you are going
to record their lunch activity as a sales activity.