Suggestions for Access queries?

Reply #12

SergeM — Wed, 18 Feb 2015 18:01:12 GMT

No, it is just frequency of couples, like I wrote above. I continued on my website and updated tables. See https://emuis.be/euromillions for Euromillions. There is no pick 3. If you feel the vocation to do input, then I do the charts. It does not make much sense for me to post charts here, while I can update charts automatically with done input. I hope that you understand that. Also I don't want to loose time with number input instead of keeping busy organizing site and programs, also continue s... [ More ]

Reply #11

CARBOB — Wed, 18 Feb 2015 11:58:50 GMT

My guess is either, digits,roots, or LDR following each other.

Reply #10

justawiner — Wed, 18 Feb 2015 11:43:44 GMT

i have no idea what this is serge and i bet alot of the viewers haven't responded bcuz of the same.

i wont mind you explaining it if you wish.

Reply #9

SergeM — Sat, 07 Feb 2015 23:23:41 GMT

first couple

Reply #8

lakerben — Sat, 07 Feb 2015 03:40:44 GMT

Interesting Serge what is this

Reply #7

SergeM — Thu, 22 Jan 2015 00:22:44 GMT

I did a frequency chart with 4 number combinations using SQL. It takes like 10 minutes or longer, while java does this in seconds.

Reply #6

SergeM — Sun, 18 Jan 2015 19:21:26 GMT

N1 N1_Following Expression00Zip

4 9 51

3 3 47

8 8 47

9 4 47

4 7 46

6 3 46

3 9 45

8 4 45

9 3 45

2 8 44

3 7 44

4 1 44

5 8 44

7 4 44

4 5 43

7 8 43

9 0 43

2 2 42

4 6 42

7 3 42

7 7 42

2 4 41

2 9 41

3 2 41

6 7 41

7 6 41

8 7 41

0 0 40

0 5 40

8 5 40

8 9 40

9 8 40

3 4 39

4 0 39

4 8 39

6 4 39

8 0 39

8 3 39

0 4 38

Reply #5

SergeM — Sun, 18 Jan 2015 18:53:19 GMT

Excel Crosstab also does good things.

First couple

N1 \ N2 0 1 2 3 4 5 6 7 8 9 Total

0 41 48 27 30 27 29 32 37 36 40 347

1 31 36 47 27 43 32 29 29 36 28 338

2 31 52 37 33 32 42 38 34 30 39 368

3 36 38 42 29 35 36 42 51 35 38 382

4 50 26 37 48 34 47 38 47 29 45 401

5 37 38 44 26 34 35 43 31 31 34 353

6 48 37 33 29 33 37 41 22 40 39 359

7 35 49 39 34 39 44 34 40 25 46 385

8 41 37 34 43 42 33 37 53 40 39 399

9 30 50 43 43 31 32 41 34 34 36 37... [ More ]

Reply #4

SergeM — Sat, 17 Jan 2015 19:22:12 GMT

Loading data into Excel, I queried further by coding in small steps.

Score Resultfrequency

0 22

1 98

2 166

3 204

4 178

5 164

6 86

7 51

8 21

9 5

10 5

22 combinations were not drawn until today, for the used database.

Reply #3

SergeM — Wed, 14 Jan 2015 00:45:56 GMT

This is the list for sums and O/E.

I passed by Excel.

Som P3 O/E

0 000 EEE

1 001 EEO

2 002 EEE

3 003 EEO

4 004 EEE

5 005 EEO

6 006 EEE

7 007 EEO

8 008 EEE

9 009 EEO

1 010 EOE

2 011 EOO

3 012 EOE

4 013 EOO

5 014 EOE

6 015 EOO

7 016 EOE

8 017 EOO

9 018 EOE

10 019 EOO

2 020 EEE

3 021 EEO

4 022 EEE

5 023 EEO

6 024 EEE

7 025 EEO

8 026 EEE

9 027 EEO

10... [ More ]

Reply #2

SergeM — Tue, 13 Jan 2015 23:33:30 GMT

Oh, you want to filter and get the lists.

Reply #1

Igamble — Tue, 13 Jan 2015 21:03:09 GMT

Input this vector trajectory in an empty browser position

https://www.lotterypost.com/charts/pick3/rootsums

This explains how 2 select and offers a visual of the parameter queries

https://www.lotterypost.com/inspector3.asp

ex sum 13

EEO 57 76.0% 049 058 067 076 085 094 148 166 184 229 238 247 256 265 274 283 292 328 346 364 382 409 418 427 436 445 454 463 472 481 490 508 526 544 562 580 607 616 625 634 643 652 661 670 706 724 742 760 805 814 823 832 841 850 904 922 940

OOO 1... [ More ]

Suggestions for Access queries?

SergeM — Tue, 13 Jan 2015 20:10:02 GMT

I picked up querying in Access, do you have suggestions?

A query giving sums and their count in Pick3:

Sum Count

0 1

1 3

2 6

3 10

4 15

5 21

6 28

7 36

8 45

9 55

10 63

11 69

12 73

13 75

14 75

15 73

16 69

17 63

18 55

19 45

20 36

21 28

22 21

23 15

24 10

25 6

26 3

27 1