Search results

I'm sure you are correct, the architecture could probably be a lot better. The application's main purpose is to support our charity numbers game in which players pick a series of five numbers from 1 to 59. Some have more than one set of numbers, (hence a separate table). These numbers are then...

Hi Bob The numbers are split across fields because the relative position of the integers is normally critical to the outcome. However, this time I'm looking specifically for groups which contain the same integers, though in various orders. The best way to summarise this seemed to be to get them...

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...

Thank you Bob, I will see if I can bend my somewhat puny mind to adapt this. Your assistance is very much appreciated. :)

Thank you, I wouldn't have spotted this issue; always a problem when you don't really know what you are doing :confused:

I tried doing this with a nested query, but it doesn't work, presumably because the random number is generated dynamically, rather than being a constant. This is why I thought temporarily dropping the numbers into an array might help, but I'm not sure how to code this...

It doesn't make a lot of sense to me either, but that's the MS code and it does work. Unfortunately the question of how you get five different numbers in a sequence remains :(

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...