Search results

I have a table comprising integers in separate columns and need to create a query which will arrange them in ascending order (e.g. from 5 | 2 | 1 | 4 | 3 to 1 | 2 | 3 | 4 | 5). I thought this might be possible with a nested iif statement, but it's looking horribly convoluted. Can anyone suggest...

I have some output from a piece of code which produces five integers, randomly selected between 1 and 59; each is comma delimited like so: ,21,19,54,16,59 ,45,31,44,6,58 ,54,31,3,2,24 ,40,3,13,34,46 ,52,36,7,17,56 ,34,14,33,35,56 I need to get...

I need to add a facility to my application which will generate random numbers which I can then append to a table. The output must be five numbers between 1 & 59 and each must be different (i.e. must not repeat a number in a line). First: Int((59-1+1)*Rnd()+1) produces the right number range...