Welcome Guest
Log In | Register )
You last visited December 4, 2016, 5:20 pm
All times shown are
Eastern Time (GMT-5:00)

Suggestions for Access queries?

Topic closed. 12 replies. Last post 2 years ago by SergeM.

Page 1 of 1
51
PrintE-mailLink
SergeM's avatar - slow icon.png
Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
Posted: January 13, 2015, 3:10 pm - IP Logged

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

A query giving sums and their count in Pick3:

SumCount
01
13
26
310
415
521
628
736
845
955
1063
1169
1273
1375
1475
1573
1669
1763
1855
1945
2036
2128
2221
2315
2410
256
263
271
    Igamble's avatar - spider
    nj
    United States
    Member #145657
    August 10, 2013
    974 Posts
    Offline
    Posted: January 13, 2015, 4:03 pm - IP Logged

    Input this vector trajectory in an empty browser position

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

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

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

    ex sum 13

    EEO5776.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
    OOO1824.0%139 157 175 193 319 337 355 373 391 517 535 553 571 715 733 751 913 931

     

    Congrats ! Most users look for this info after 15+years of analysis.

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: January 13, 2015, 6:33 pm - IP Logged

      Oh, you want to filter and get the lists.

        SergeM's avatar - slow icon.png
        Economy class
        Belgium
        Member #123700
        February 27, 2012
        4035 Posts
        Offline
        Posted: January 13, 2015, 7:45 pm - IP Logged

        This is the list for sums and O/E.
        I passed by Excel.

        SomP3O/E
        0000EEE
        1001EEO
        2002EEE
        3003EEO
        4004EEE
        5005EEO
        6006EEE
        7007EEO
        8008EEE
        9009EEO
        1010EOE
        2011EOO
        3012EOE
        4013EOO
        5014EOE
        6015EOO
        7016EOE
        8017EOO
        9018EOE
        10019EOO
        2020EEE
        3021EEO
        4022EEE
        5023EEO
        6024EEE
        7025EEO
        8026EEE
        9027EEO
        10028EEE
        11029EEO
        3030EOE
        4031EOO
        5032EOE
        6033EOO
        7034EOE
        8035EOO
        9036EOE
        10037EOO
        11038EOE
        12039EOO
        4040EEE
        5041EEO
        6042EEE
        7043EEO
        8044EEE
        9045EEO
        10046EEE
        11047EEO
        12048EEE
        13049EEO
        5050EOE
        6051EOO
        7052EOE
        8053EOO
        9054EOE
        10055EOO
        11056EOE
        12057EOO
        13058EOE
        14059EOO
        6060EEE
        7061EEO
        8062EEE
        9063EEO
        10064EEE
        11065EEO
        12066EEE
        13067EEO
        14068EEE
        15069EEO
        7070EOE
        8071EOO
        9072EOE
        10073EOO
        11074EOE
        12075EOO
        13076EOE
        14077EOO
        15078EOE
        16079EOO
        8080EEE
        9081EEO
        10082EEE
        11083EEO
        12084EEE
        13085EEO
        14086EEE
        15087EEO
        16088EEE
        17089EEO
        9090EOE
        10091EOO
        11092EOE
        12093EOO
        13094EOE
        14095EOO
        15096EOE
        16097EOO
        17098EOE
        18099EOO
        1100OEE
        2101OEO
        3102OEE
        4103OEO
        5104OEE
        6105OEO
        7106OEE
        8107OEO
        9108OEE
        10109OEO
        2110OOE
        3111OOO
        4112OOE
        5113OOO
        6114OOE
        7115OOO
        8116OOE
        9117OOO
        10118OOE
        11119OOO
        3120OEE
        4121OEO
        5122OEE
        6123OEO
        7124OEE
        8125OEO
        9126OEE
        10127OEO
        11128OEE
        12129OEO
        4130OOE
        5131OOO
        6132OOE
        7133OOO
        8134OOE
        9135OOO
        10136OOE
        11137OOO
        12138OOE
        13139OOO
        5140OEE
        6141OEO
        7142OEE
        8143OEO
        9144OEE
        10145OEO
        11146OEE
        12147OEO
        13148OEE
        14149OEO
        6150OOE
        7151OOO
        8152OOE
        9153OOO
        10154OOE
        11155OOO
        12156OOE
        13157OOO
        14158OOE
        15159OOO
        7160OEE
        8161OEO
        9162OEE
        10163OEO
        11164OEE
        12165OEO
        13166OEE
        14167OEO
        15168OEE
        16169OEO
        8170OOE
        9171OOO
        10172OOE
        11173OOO
        12174OOE
        13175OOO
        14176OOE
        15177OOO
        16178OOE
        17179OOO
        9180OEE
        10181OEO
        11182OEE
        12183OEO
        13184OEE
        14185OEO
        15186OEE
        16187OEO
        17188OEE
        18189OEO
        10190OOE
        11191OOO
        12192OOE
        13193OOO
        14194OOE
        15195OOO
        16196OOE
        17197OOO
        18198OOE
        19199OOO
        2200EEE
        3201EEO
        4202EEE
        5203EEO
        6204EEE
        7205EEO
        8206EEE
        9207EEO
        10208EEE
        11209EEO
        3210EOE
        4211EOO
        5212EOE
        6213EOO
        7214EOE
        8215EOO
        9216EOE
        10217EOO
        11218EOE
        12219EOO
        4220EEE
        5221EEO
        6222EEE
        7223EEO
        8224EEE
        9225EEO
        10226EEE
        11227EEO
        12228EEE
        13229EEO
        5230EOE
        6231EOO
        7232EOE
        8233EOO
        9234EOE
        10235EOO
        11236EOE
        12237EOO
        13238EOE
        14239EOO
        6240EEE
        7241EEO
        8242EEE
        9243EEO
        10244EEE
        11245EEO
        12246EEE
        13247EEO
        14248EEE
        15249EEO
        7250EOE
        8251EOO
        9252EOE
        10253EOO
        11254EOE
        12255EOO
        13256EOE
        14257EOO
        15258EOE
        16259EOO
        8260EEE
        9261EEO
        10262EEE
        11263EEO
        12264EEE
        13265EEO
        14266EEE
        15267EEO
        16268EEE
        17269EEO
        9270EOE
        10271EOO
        11272EOE
        12273EOO
        13274EOE
        14275EOO
        15276EOE
        16277EOO
        17278EOE
        18279EOO
        10280EEE
        11281EEO
        12282EEE
        13283EEO
        14284EEE
        15285EEO
        16286EEE
        17287EEO
        18288EEE
        19289EEO
        11290EOE
        12291EOO
        13292EOE
        14293EOO
        15294EOE
        16295EOO
        17296EOE
        18297EOO
        19298EOE
        20299EOO
        3300OEE
        4301OEO
        5302OEE
        6303OEO
        7304OEE
        8305OEO
        9306OEE
        10307OEO
        11308OEE
        12309OEO
        4310OOE
        5311OOO
        6312OOE
        7313OOO
        8314OOE
        9315OOO
        10316OOE
        11317OOO
        12318OOE
        13319OOO
        5320OEE
        6321OEO
        7322OEE
        8323OEO
        9324OEE
        10325OEO
        11326OEE
        12327OEO
        13328OEE
        14329OEO
        6330OOE
        7331OOO
        8332OOE
        9333OOO
        10334OOE
        11335OOO
        12336OOE
        13337OOO
        14338OOE
        15339OOO
        7340OEE
        8341OEO
        9342OEE
        10343OEO
        11344OEE
        12345OEO
        13346OEE
        14347OEO
        15348OEE
        16349OEO
        8350OOE
        9351OOO
        10352OOE
        11353OOO
        12354OOE
        13355OOO
        14356OOE
        15357OOO
        16358OOE
        17359OOO
        9360OEE
        10361OEO
        11362OEE
        12363OEO
        13364OEE
        14365OEO
        15366OEE
        16367OEO
        17368OEE
        18369OEO
        10370OOE
        11371OOO
        12372OOE
        13373OOO
        14374OOE
        15375OOO
        16376OOE
        17377OOO
        18378OOE
        19379OOO
        11380OEE
        12381OEO
        13382OEE
        14383OEO
        15384OEE
        16385OEO
        17386OEE
        18387OEO
        19388OEE
        20389OEO
        12390OOE
        13391OOO
        14392OOE
        15393OOO
        16394OOE
        17395OOO
        18396OOE
        19397OOO
        20398OOE
        21399OOO
        4400EEE
        5401EEO
        6402EEE
        7403EEO
        8404EEE
        9405EEO
        10406EEE
        11407EEO
        12408EEE
        13409EEO
        5410EOE
        6411EOO
        7412EOE
        8413EOO
        9414EOE
        10415EOO
        11416EOE
        12417EOO
        13418EOE
        14419EOO
        6420EEE
        7421EEO
        8422EEE
        9423EEO
        10424EEE
        11425EEO
        12426EEE
        13427EEO
        14428EEE
        15429EEO
        7430EOE
        8431EOO
        9432EOE
        10433EOO
        11434EOE
        12435EOO
        13436EOE
        14437EOO
        15438EOE
        16439EOO
        8440EEE
        9441EEO
        10442EEE
        11443EEO
        12444EEE
        13445EEO
        14446EEE
        15447EEO
        16448EEE
        17449EEO
        9450EOE
        10451EOO
        11452EOE
        12453EOO
        13454EOE
        14455EOO
        15456EOE
        16457EOO
        17458EOE
        18459EOO
        10460EEE
        11461EEO
        12462EEE
        13463EEO
        14464EEE
        15465EEO
        16466EEE
        17467EEO
        18468EEE
        19469EEO
        11470EOE
        12471EOO
        13472EOE
        14473EOO
        15474EOE
        16475EOO
        17476EOE
        18477EOO
        19478EOE
        20479EOO
        12480EEE
        13481EEO
        14482EEE
        15483EEO
        16484EEE
        17485EEO
        18486EEE
        19487EEO
        20488EEE
        21489EEO
        13490EOE
        14491EOO
        15492EOE
        16493EOO
        17494EOE
        18495EOO
        19496EOE
        20497EOO
        21498EOE
        22499EOO
        5500OEE
        6501OEO
        7502OEE
        8503OEO
        9504OEE
        10505OEO
        11506OEE
        12507OEO
        13508OEE
        14509OEO
        6510OOE
        7511OOO
        8512OOE
        9513OOO
        10514OOE
        11515OOO
        12516OOE
        13517OOO
        14518OOE
        15519OOO
        7520OEE
        8521OEO
        9522OEE
        10523OEO
        11524OEE
        12525OEO
        13526OEE
        14527OEO
        15528OEE
        16529OEO
        8530OOE
        9531OOO
        10532OOE
        11533OOO
        12534OOE
        13535OOO
        14536OOE
        15537OOO
        16538OOE
        17539OOO
        9540OEE
        10541OEO
        11542OEE
        12543OEO
        13544OEE
        14545OEO
        15546OEE
        16547OEO
        17548OEE
        18549OEO
        10550OOE
        11551OOO
        12552OOE
        13553OOO
        14554OOE
        15555OOO
        16556OOE
        17557OOO
        18558OOE
        19559OOO
        11560OEE
        12561OEO
        13562OEE
        14563OEO
        15564OEE
        16565OEO
        17566OEE
        18567OEO
        19568OEE
        20569OEO
        12570OOE
        13571OOO
        14572OOE
        15573OOO
        16574OOE
        17575OOO
        18576OOE
        19577OOO
        20578OOE
        21579OOO
        13580OEE
        14581OEO
        15582OEE
        16583OEO
        17584OEE
        18585OEO
        19586OEE
        20587OEO
        21588OEE
        22589OEO
        14590OOE
        15591OOO
        16592OOE
        17593OOO
        18594OOE
        19595OOO
        20596OOE
        21597OOO
        22598OOE
        23599OOO
        6600EEE
        7601EEO
        8602EEE
        9603EEO
        10604EEE
        11605EEO
        12606EEE
        13607EEO
        14608EEE
        15609EEO
        7610EOE
        8611EOO
        9612EOE
        10613EOO
        11614EOE
        12615EOO
        13616EOE
        14617EOO
        15618EOE
        16619EOO
        8620EEE
        9621EEO
        10622EEE
        11623EEO
        12624EEE
        13625EEO
        14626EEE
        15627EEO
        16628EEE
        17629EEO
        9630EOE
        10631EOO
        11632EOE
        12633EOO
        13634EOE
        14635EOO
        15636EOE
        16637EOO
        17638EOE
        18639EOO
        10640EEE
        11641EEO
        12642EEE
        13643EEO
        14644EEE
        15645EEO
        16646EEE
        17647EEO
        18648EEE
        19649EEO
        11650EOE
        12651EOO
        13652EOE
        14653EOO
        15654EOE
        16655EOO
        17656EOE
        18657EOO
        19658EOE
        20659EOO
        12660EEE
        13661EEO
        14662EEE
        15663EEO
        16664EEE
        17665EEO
        18666EEE
        19667EEO
        20668EEE
        21669EEO
        13670EOE
        14671EOO
        15672EOE
        16673EOO
        17674EOE
        18675EOO
        19676EOE
        20677EOO
        21678EOE
        22679EOO
        14680EEE
        15681EEO
        16682EEE
        17683EEO
        18684EEE
        19685EEO
        20686EEE
        21687EEO
        22688EEE
        23689EEO
        15690EOE
        16691EOO
        17692EOE
        18693EOO
        19694EOE
        20695EOO
        21696EOE
        22697EOO
        23698EOE
        24699EOO
        7700OEE
        8701OEO
        9702OEE
        10703OEO
        11704OEE
        12705OEO
        13706OEE
        14707OEO
        15708OEE
        16709OEO
        8710OOE
        9711OOO
        10712OOE
        11713OOO
        12714OOE
        13715OOO
        14716OOE
        15717OOO
        16718OOE
        17719OOO
        9720OEE
        10721OEO
        11722OEE
        12723OEO
        13724OEE
        14725OEO
        15726OEE
        16727OEO
        17728OEE
        18729OEO
        10730OOE
        11731OOO
        12732OOE
        13733OOO
        14734OOE
        15735OOO
        16736OOE
        17737OOO
        18738OOE
        19739OOO
        11740OEE
        12741OEO
        13742OEE
        14743OEO
        15744OEE
        16745OEO
        17746OEE
        18747OEO
        19748OEE
        20749OEO
        12750OOE
        13751OOO
        14752OOE
        15753OOO
        16754OOE
        17755OOO
        18756OOE
        19757OOO
        20758OOE
        21759OOO
        13760OEE
        14761OEO
        15762OEE
        16763OEO
        17764OEE
        18765OEO
        19766OEE
        20767OEO
        21768OEE
        22769OEO
        14770OOE
        15771OOO
        16772OOE
        17773OOO
        18774OOE
        19775OOO
        20776OOE
        21777OOO
        22778OOE
        23779OOO
        15780OEE
        16781OEO
        17782OEE
        18783OEO
        19784OEE
        20785OEO
        21786OEE
        22787OEO
        23788OEE
        24789OEO
        16790OOE
        17791OOO
        18792OOE
        19793OOO
        20794OOE
        21795OOO
        22796OOE
        23797OOO
        24798OOE
        25799OOO
        8800EEE
        9801EEO
        10802EEE
        11803EEO
        12804EEE
        13805EEO
        14806EEE
        15807EEO
        16808EEE
        17809EEO
        9810EOE
        10811EOO
        11812EOE
        12813EOO
        13814EOE
        14815EOO
        15816EOE
        16817EOO
        17818EOE
        18819EOO
        10820EEE
        11821EEO
        12822EEE
        13823EEO
        14824EEE
        15825EEO
        16826EEE
        17827EEO
        18828EEE
        19829EEO
        11830EOE
        12831EOO
        13832EOE
        14833EOO
        15834EOE
        16835EOO
        17836EOE
        18837EOO
        19838EOE
        20839EOO
        12840EEE
        13841EEO
        14842EEE
        15843EEO
        16844EEE
        17845EEO
        18846EEE
        19847EEO
        20848EEE
        21849EEO
        13850EOE
        14851EOO
        15852EOE
        16853EOO
        17854EOE
        18855EOO
        19856EOE
        20857EOO
        21858EOE
        22859EOO
        14860EEE
        15861EEO
        16862EEE
        17863EEO
        18864EEE
        19865EEO
        20866EEE
        21867EEO
        22868EEE
        23869EEO
        15870EOE
        16871EOO
        17872EOE
        18873EOO
        19874EOE
        20875EOO
        21876EOE
        22877EOO
        23878EOE
        24879EOO
        16880EEE
        17881EEO
        18882EEE
        19883EEO
        20884EEE
        21885EEO
        22886EEE
        23887EEO
        24888EEE
        25889EEO
        17890EOE
        18891EOO
        19892EOE
        20893EOO
        21894EOE
        22895EOO
        23896EOE
        24897EOO
        25898EOE
        26899EOO
        9900OEE
        10901OEO
        11902OEE
        12903OEO
        13904OEE
        14905OEO
        15906OEE
        16907OEO
        17908OEE
        18909OEO
        10910OOE
        11911OOO
        12912OOE
        13913OOO
        14914OOE
        15915OOO
        16916OOE
        17917OOO
        18918OOE
        19919OOO
        11920OEE
        12921OEO
        13922OEE
        14923OEO
        15924OEE
        16925OEO
        17926OEE
        18927OEO
        19928OEE
        20929OEO
        12930OOE
        13931OOO
        14932OOE
        15933OOO
        16934OOE
        17935OOO
        18936OOE
        19937OOO
        20938OOE
        21939OOO
        13940OEE
        14941OEO
        15942OEE
        16943OEO
        17944OEE
        18945OEO
        19946OEE
        20947OEO
        21948OEE
        22949OEO
        14950OOE
        15951OOO
        16952OOE
        17953OOO
        18954OOE
        19955OOO
        20956OOE
        21957OOO
        22958OOE
        23959OOO
        15960OEE
        16961OEO
        17962OEE
        18963OEO
        19964OEE
        20965OEO
        21966OEE
        22967OEO
        23968OEE
        24969OEO
        16970OOE
        17971OOO
        18972OOE
        19973OOO
        20974OOE
        21975OOO
        22976OOE
        23977OOO
        24978OOE
        25979OOO
        17980OEE
        18981OEO
        19982OEE
        20983OEO
        21984OEE
        22985OEO
        23986OEE
        24987OEO
        25988OEE
        26989OEO
        18990OOE
        19991OOO
        20992OOE
        21993OOO
        22994OOE
        23995OOO
        24996OOE
        25997OOO
        26998OOE
        27999OOO

          SergeM's avatar - slow icon.png
          Economy class
          Belgium
          Member #123700
          February 27, 2012
          4035 Posts
          Offline
          Posted: January 17, 2015, 2:22 pm - IP Logged

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

          ScoreResultfrequency
          022
          198
          2166
          3204
          4178
          5164
          686
          751
          821
          95
          105

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

            SergeM's avatar - slow icon.png
            Economy class
            Belgium
            Member #123700
            February 27, 2012
            4035 Posts
            Offline
            Posted: January 18, 2015, 1:53 pm - IP Logged

            Excel Crosstab also does good things.

            First couple

            N1 \ N20123456789Total
            041482730272932373640347
            131364727433229293628338
            231523733324238343039368
            336384229353642513538382
            450263748344738472945401
            537384426343543313134353
            648373329333741224039359
            735493934394434402546385
            841373443423337534039399
            930504343313241343436374
            Total3804113833423503673753783363843706

              SergeM's avatar - slow icon.png
              Economy class
              Belgium
              Member #123700
              February 27, 2012
              4035 Posts
              Offline
              Posted: January 18, 2015, 2:21 pm - IP Logged
              N1N1_FollowingExpression00Zip
              4951
              3347
              8847
              9447
              4746
              6346
              3945
              8445
              9345
              2844
              3744
              4144
              5844
              7444
              4543
              7843
              9043
              2242
              4642
              7342
              7742
              2441
              2941
              3241
              6741
              7641
              8741
              0040
              0540
              8540
              8940
              9840
              3439
              4039
              4839
              6439
              8039
              8339
              0438
              1138
              1238
              1738
              5438
              6838
              8638
              9238
              0237
              2337
              3637
              3837
              5537
              7137
              0736
              0836
              1336
              2636
              5036
              6536
              6636
              9736
              1435
              4235
              5935
              7235
              8235
              2534
              4434
              5334
              5634
              6234
              7034
              7534
              8134
              9534
              1033
              3133
              5133
              5233
              6933
              7933
              9633
              0932
              1632
              1932
              2732
              6132
              9932
              1831
              2131
              0130
              0630
              2030
              3530
              3029
              5729
              0328
              4328
              9126
              1525
              6024
                SergeM's avatar - slow icon.png
                Economy class
                Belgium
                Member #123700
                February 27, 2012
                4035 Posts
                Offline
                Posted: January 21, 2015, 7:22 pm - IP Logged

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

                  lakerben's avatar - spherewall
                  New Mexico
                  United States
                  Member #86099
                  January 29, 2010
                  11117 Posts
                  Online
                  Posted: February 6, 2015, 10:40 pm - IP Logged

                  Excel Crosstab also does good things.

                  First couple

                  N1 \ N20123456789Total
                  041482730272932373640347
                  131364727433229293628338
                  231523733324238343039368
                  336384229353642513538382
                  450263748344738472945401
                  537384426343543313134353
                  648373329333741224039359
                  735493934394434402546385
                  841373443423337534039399
                  930504343313241343436374
                  Total3804113833423503673753783363843706

                  Interesting Serge what is this?

                  How about them cowboys!

                   

                   

                  US Flag

                    SergeM's avatar - slow icon.png
                    Economy class
                    Belgium
                    Member #123700
                    February 27, 2012
                    4035 Posts
                    Offline
                    Posted: February 7, 2015, 6:23 pm - IP Logged

                    Interesting Serge what is this?

                    first couple

                      Avatar
                      GA
                      United States
                      Member #158157
                      August 13, 2014
                      99 Posts
                      Offline
                      Posted: February 18, 2015, 6:43 am - IP Logged

                      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.

                        CARBOB's avatar - FL LOTTERY_LOGO.png
                        ORLANDO, FLORIDA
                        United States
                        Member #4924
                        June 3, 2004
                        5893 Posts
                        Offline
                        Posted: February 18, 2015, 6:58 am - IP Logged

                        Excel Crosstab also does good things.

                        First couple

                        N1 \ N20123456789Total
                        041482730272932373640347
                        131364727433229293628338
                        231523733324238343039368
                        336384229353642513538382
                        450263748344738472945401
                        537384426343543313134353
                        648373329333741224039359
                        735493934394434402546385
                        841373443423337534039399
                        930504343313241343436374
                        Total3804113833423503673753783363843706

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

                          SergeM's avatar - slow icon.png
                          Economy class
                          Belgium
                          Member #123700
                          February 27, 2012
                          4035 Posts
                          Offline
                          Posted: February 18, 2015, 1:01 pm - IP Logged

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

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

                          So never mind the chart above done in Excel.