[土法子] 用 MS-Access 統計歷史出號

micmag

[Step 1] 建立資料表

Table Name : MarkSix-Result

欄位名稱	資料類形	長度	註解
TurnName	文字	10	期數
Num1	文字	10	第1個碼
Num2	文字	10	第2個碼
Num3	文字	10	第3個碼
Num4	文字	10	第4個碼
Num5	文字	10	第5個碼
Num6	文字	10	第6個碼
Bon1	文字	10	特別碼

[ 本帖最後由 micmag 於 2006-11-8 07:15 PM 編輯 ]

micmag

[Step 2] 建立主查詢Querry
Querry Name : Q_MarkSix-Result

SELECT [MarkSix-Result].*
FROM [MarkSix-Result]
WHERE ((([MarkSix-Result].TurnName)>="1"));

micmag

[Step 3] 逐一建立以下集合查詢 Union Querry

Querry Name : Q_Result(A)

SELECT "(" & [Num1] & ")"  AS A
FROM [Q_MarkSix-Result]

UNION ALL SELECT "(" & [Num2] & ")"  AS A
FROM [Q_MarkSix-Result]

UNION ALL SELECT "(" & [Num3] & ")"  AS A
FROM [Q_MarkSix-Result]

UNION ALL SELECT "(" & [Num4] & ")"  AS A
FROM [Q_MarkSix-Result]

UNION ALL SELECT "(" & [Num5] & ")"  AS A
FROM [Q_MarkSix-Result]

UNION ALL SELECT "(" & [Num6] & ")"  AS A
FROM [Q_MarkSix-Result];

micmag

Querry Name : Q_Result(AB)


SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL SELECT "(" & [Num1] & ")" & "(" & [Num3] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL SELECT "(" & [Num1] & ")" & "(" & [Num4] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL SELECT "(" & [Num1] & ")" & "(" & [Num5] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL  SELECT "(" & [Num1] & ")" & "(" & [Num6] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL  SELECT "(" & [Num2] & ")" & "(" & [Num3] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL  SELECT "(" & [Num2] & ")" & "(" & [Num4] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL  SELECT "(" & [Num2] & ")" & "(" & [Num5] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL  SELECT "(" & [Num2] & ")" & "(" & [Num6] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL  SELECT "(" & [Num3] & ")" & "(" & [Num4] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL  SELECT "(" & [Num3] & ")" & "(" & [Num5] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL  SELECT "(" & [Num3] & ")" & "(" & [Num6] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION  ALL SELECT "(" & [Num4] & ")" & "(" & [Num5] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL  SELECT "(" & [Num4] & ")" & "(" & [Num6] & ")" AS AB
FROM [Q_MarkSix-Result]

UNION ALL SELECT "(" & [Num5] & ")" & "(" & [Num6] & ")" AS AB
FROM [Q_MarkSix-Result];

micmag

Querry Name : Q_Result(ABC)


SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num3] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num4] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num5] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION ALL  SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION ALL  SELECT "(" & [Num1] & ")" & "(" & [Num3] & ")"  & "(" & [Num4] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION ALL  SELECT "(" & [Num1] & ")" & "(" & [Num3] & ")"  & "(" & [Num5] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num3] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num4] & ")"  & "(" & [Num5] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num4] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num5] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num2] & ")" & "(" & [Num3] & ")"  & "(" & [Num4] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num2] & ")" & "(" & [Num3] & ")"  & "(" & [Num5] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num2] & ")" & "(" & [Num3] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num2] & ")" & "(" & [Num4] & ")"  & "(" & [Num5] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION ALL  SELECT "(" & [Num2] & ")" & "(" & [Num4] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num2] & ")" & "(" & [Num5] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION ALL  SELECT "(" & [Num3] & ")" & "(" & [Num4] & ")"  & "(" & [Num5] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num3] & ")" & "(" & [Num4] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num3] & ")" & "(" & [Num5] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

UNION ALL SELECT "(" & [Num4] & ")" & "(" & [Num5] & ")"  & "(" & [Num6] & ")" AS ABC
FROM [Q_MarkSix-Result];

micmag

Querry Name : Q_Result(ABCD)

SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num3] & ")" & "(" & [Num4] & ")"  AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num3] & ")" & "(" & [Num5] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num3] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num4] & ")" & "(" & [Num5] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num4] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num3] & ")"  & "(" & [Num4] & ")" & "(" & [Num5] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num3] & ")"  & "(" & [Num4] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num3] & ")"  & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num4] & ")"  & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num2] & ")" & "(" & [Num3] & ")"  & "(" & [Num4] & ")" & "(" & [Num5] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION ALL  SELECT "(" & [Num2] & ")" & "(" & [Num3] & ")"  & "(" & [Num4] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num2] & ")" & "(" & [Num3] & ")"  & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num2] & ")" & "(" & [Num4] & ")"  & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

UNION ALL SELECT "(" & [Num3] & ")" & "(" & [Num4] & ")"  & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCD
FROM [Q_MarkSix-Result];

micmag

Querry Name : Q_Result(ABCDE)


SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num3] & ")" & "(" & [Num4] & ")"  & "(" & [Num5] & ")" AS ABCDE
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num3] & ")" & "(" & [Num4] & ")" & "(" & [Num6] & ")" AS ABCDE
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num3] & ")" & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCDE
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num2] & ")"  & "(" & [Num4] & ")" & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCDE
FROM [Q_MarkSix-Result];

UNION  ALL SELECT "(" & [Num1] & ")" & "(" & [Num3] & ")"  & "(" & [Num4] & ")" & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCDE
FROM [Q_MarkSix-Result];

UNION ALL SELECT "(" & [Num2] & ")" & "(" & [Num3] & ")"  & "(" & [Num4] & ")" & "(" & [Num5] & ")" & "(" & [Num6] & ")" AS ABCDE
FROM [Q_MarkSix-Result];

micmag

隨著一聲新年到，『財神爺爺』看顧您了，
你獲得了『財神爺爺』贈送現金818個美元。

[Step 4] 逐一建立以下查詢 Select Querry       用途 : {{看組合歷史出現次數}}

Querry Name: Q_(ABC)     << == 看3個碼組合
SELECT [Q_Result(ABC)].ABC, Count([Q_Result(ABC)].ABC) AS ABC之筆數
FROM [Q_Result(ABC)]
GROUP BY [Q_Result(ABC)].ABC
ORDER BY Count([Q_Result(ABC)].ABC) DESC;

Querry Name: Q_(ABCD)     << == 看4個碼組合
SELECT [Q_Result(ABCD)].ABCD, Count([Q_Result(ABCD)].ABCD) AS ABCD之筆數
FROM [Q_Result(ABCD)]
GROUP BY [Q_Result(ABCD)].ABCD
HAVING (((Count([Q_Result(ABCD)].ABCD))>1));

Querry Name: Q_(ABCDE)     << == 看5個碼組合
SELECT [Q_Result(ABCDE)].ABCDE, Count([Q_Result(ABCDE)].ABCDE) AS ABCDE之筆數
FROM [Q_Result(ABCDE)]
GROUP BY [Q_Result(ABCDE)].ABCDE
HAVING (((Count([Q_Result(ABCDE)].ABCDE))>1))
ORDER BY Count([Q_Result(ABCDE)].ABCDE) DESC;

micmag

[Step 5] 打開MarkSix-Result資料表逐期輸入
[Step 6] 點激巳做好的Select Querry 看歷史出現次數

micmag

隨著一聲新年到，『富神爺爺』看顧您了，
你獲得了『富神爺爺』贈送現金4036個美元。

[Example] 某國內彩票歷史號共629期

按Select Querry 4字組合為~~

ABCD	ABCD筆數
(08)(12)(21)(25)	4
(05)(29)(35)(36)	3
(01)(11)(24)(28)	3
(01)(11)(24)(36)	3
(07)(18)(26)(28)	3
(07)(19)(23)(34)	3
(14)(22)(23)(33)	3
(08)(11)(20)(35)	3
(07)(11)(17)(21)	3
(18)(22)(30)(32)	3
(13)(22)(25)(28)	3
(04)(14)(22)(23)	3
(04)(14)(22)(33)	3
(04)(14)(23)(33)	3
(08)(21)(24)(29)	3
(04)(22)(23)(33)	3
(16)(17)(22)(23)	3
(15)(21)(24)(34)	3
(18)(23)(24)(34)	3
(01)(07)(11)(24)	3
(07)(11)(15)(21)	3
(06)(09)(13)(33)	3
(12)(21)(33)(35)	3
(11)(17)(20)(35)	3
(03)(22)(23)(33)	2
(04)(12)(23)(31)	2
(03)(19)(23)(34)	2
(04)(13)(19)(20)	2
(03)(18)(28)(35)	2

[ 本帖最後由 micmag 於 2006-11-8 07:39 PM 編輯 ]

micmag

按Select Querry 5字組合為~~

ABCDE	ABCDE之筆數
(04)(14)(22)(23)(33)	3
(03)(14)(22)(23)(33)	2
(01)(07)(11)(24)(36)	2
(01)(12)(27)(29)(33)	2
(02)(03)(08)(29)(32)	2
(03)(04)(14)(22)(23)	2
(03)(04)(14)(22)(33)	2
(03)(04)(14)(23)(33)	2
(01)(03)(14)(29)(35)	2
(03)(07)(19)(23)(34)	2
(2)(4)(8)(11)(25)	2
(05)(07)(17)(29)(32)	2
(05)(13)(20)(21)(27)	2
(06)(08)(09)(13)(33)	2
(06)(09)(13)(23)(33)	2
(06)(18)(29)(31)(36)	2
(03)(04)(22)(23)(33)	2

micmag

~~乃至6字組合~~發現~~曾中大獎之號合在629例當中居然開出2次相同號~~

ABCDEF	ABCDEF之筆數
(03)(04)(14)(22)(23)(33)	2

micmag

小注怡情~~大賭見血~~玩玩好了~~~

kenny.tw

無法使用喔

micmag

原帖由 kenny.tw 於 2006-11-8 08:22 PM 發表。
無法使用喔

~~哪這如何??