1 2 3
| SELECT Delta.ID1, T_Zone.zone, [T_Zone]![zone] & " " & [T_Vendor]![vendor] & "_" & [T_Cabinettype]![cabinettype] & "_" & [T_Product Type]![Product Type] & "_" & [T_Deno]![deno] & "_" & [NBRS LIGNE] & "_" & [T_Progressif]![progressif] AS info, [NBRS LIGNE]*[t_Resultats]![deno] AS [minimum bet], ([NBRS LIGNE]*[MISE PAR LIGNE])*[t_Resultats]![deno] AS [maximum bet], Delta.Date, Delta.ID, Delta.[Mach #], T_Active.active, T_Deno.deno, T_Progressif.progressif, T_Nomprogressif.[Nom Progressif], INFO.[%], Delta.[Coin In], [t_Resultats]![Coin In]*[t_Resultats]![deno] AS [Coin IN Mad], Delta.[Games Played], Delta.[Mach Paytable Win], Delta.[Total JP], Delta.[Mach Paid Prog Payout], [t_Resultats]![deno]*([t_Resultats]![Coin In]-[Mach Paytable Win]-[Total JP]-[Mach Paid Prog Payout]) AS [Net Win Mad], Delta.[Total Drop], [t_resultats]![deno]*[Total Drop] AS [Drop Mad], Delta.[Bill In], (100-([t_Resultats]![%]*100))/100 AS [House Hold], [Coin IN Mad]*[House Hold] AS Theorique, INFO.[NBRS LIGNE], INFO.[MISE PAR LIGNE], t_Resultats.[Theo Hold Mad], DAvg("Theo Hold Mad", "t_Resultats", "[zone]= '" & [t_Resultats].[Zone] & "'") as LaMoyenneParZone FROM [T_Resultats]
FROM T_Zone INNER JOIN (T_Vendor INNER JOIN (T_Progressif INNER JOIN (T_Mas INNER JOIN (T_Deno INNER JOIN (T_Active INNER JOIN (([T_Product Type] INNER JOIN (T_Nomprogressif INNER JOIN (T_Gametype INNER JOIN (T_Gamename INNER JOIN (T_Cabinettype INNER JOIN (INFO INNER JOIN Delta ON INFO.N° = Delta.ID) ON T_Cabinettype.idcabinettype = INFO.[CABINET TYPE]) ON T_Gamename.idgamename = INFO.[GAME NAME]) ON T_Gametype.idgametype = INFO.[GAME TYPE]) ON T_Nomprogressif.[Id NomProgressif] = INFO.[NOM PROGRESSIF]) ON [T_Product Type].[Id Product Type] = INFO.[PRODUCT TYPE]) INNER JOIN t_Resultats ON Delta.ID1 = t_Resultats.ID1) ON T_Active.idactive = INFO.ACTIVE) ON T_Deno.iddeno = INFO.DENOM) ON T_Mas.idmas = INFO.MAS) ON T_Progressif.idprogressif = INFO.PROGRESSIVE) ON T_Vendor.idvendor = INFO.VENDOR) ON T_Zone.idzone = INFO.ZONE
WHERE (((T_Active.active)="oui")); |
Partager