Hi Dwain

Thanks for the link but to be honest its way above where I am in my training (I'm 4 weeks in) and to be honest that looks like a different language.

My boss said I should be able to find a case statement along the lines if a Random number genrte between 0 and 1 then between 0 and 0.3 is a 2 day stay and between 0.3 to 0.4 is a 3 day stay else 0.4 to 1 will all other days between 1 and 28.

But I don't know how to write the code.

Can you help or point me in the right direction.

Ta

Wayne