T
Tony Williams
I have a table that holds peoples names (amongst other things) I want to
allocate jobs to them with a system similar to a cab rank system ie the first
job is allocated to the first name (I'll sort the names with a query into
surname order), the second job to the next name and so on. When the list has
been exhausted I'll start again at the first name.
I suspect that this needs an extensive bit of VBA coding and if it does I
may struggle as I'm not a VBA expert.
Can anyone suggest anyway I can do this?
Many thanks
Tony
allocate jobs to them with a system similar to a cab rank system ie the first
job is allocated to the first name (I'll sort the names with a query into
surname order), the second job to the next name and so on. When the list has
been exhausted I'll start again at the first name.
I suspect that this needs an extensive bit of VBA coding and if it does I
may struggle as I'm not a VBA expert.
Can anyone suggest anyway I can do this?
Many thanks
Tony