D
Dandbuilder
Hello,
I'm trying to create a database that will find the most often numbers drawn
over a period of time.
Something along this format.
Numbers Drawn Week One: 01 02 03 04 05 06
Numbers Drawn Week Two: 01 07 08 09 10 11
Numbers Drawn Week Three: 01 07 12 13 14 15
Results: 01 07 00 00 00 00
I've created the tables for each number drawn but
cannot come up with a query to find this result.
Possibly I am approaching this in the wrong way.
Any assistance would be greatly appreciated.
Thanks in advance.
Dan........!!!!!
I'm trying to create a database that will find the most often numbers drawn
over a period of time.
Something along this format.
Numbers Drawn Week One: 01 02 03 04 05 06
Numbers Drawn Week Two: 01 07 08 09 10 11
Numbers Drawn Week Three: 01 07 12 13 14 15
Results: 01 07 00 00 00 00
I've created the tables for each number drawn but
cannot come up with a query to find this result.
Possibly I am approaching this in the wrong way.
Any assistance would be greatly appreciated.
Thanks in advance.
Dan........!!!!!