Recent content by Nandeep

Hi, i've inserted the above code in and then also added to my query but it always outputs the Case else value which is 0 in the code above. Have I made an error in the code somewhere?

Hi, that may work but I wanted to create a function to do the allocating and then call the function in my query. I have done it before but I've totally forgot how I did it

Hi the random number output is variable is already populated as number between 0 to 1000. Yes based on the value of this variable under the conditions explained above I'd like to allocate a number of between 1 to 20 for them. Hope that makes sense

Hi, I'm very new to using access VBA and functions etc so please bear in mind I may need things explaining very simply.:) I have a variable called "Output random number" which has values from 0 to 1000. I need to group these into 20 bucket as such 0 -49 =1 50 -99 = 2 100 -149 =3 . . . 950 -1000...