问尽管所有表或查询中都有数据，Access append query仍显示0行要追加

EN

INSERT INTO Handle_Temp ( Location, Host, [Date], Type, Win, Place, Show, Quinella, DailyDouble, Perfecta, Pick3, Pick9, Superfecta, Trifecta, Breakage, MinusPool, SComm, GComm, EComm, Surcharge, ArlSurcharge, StraightComm, GimComm, ExComm, Payout, NetPool )
SELECT DISTINCTROW ToteLocation.Location, ToteHost.Host, qry_handle_Combined.Date, Tracktype.Type, qry_handle_Combined.Win, qry_handle_Combined.Place, qry_handle_Combined.Show, qry_handle_Combined.Quinella, qry_handle_Combined.DailyDouble, qry_handle_Combined.Perfecta, qry_handle_Combined.Pick3, 0 AS Pick9, qry_handle_Combined.Superfecta, qry_handle_Combined.Trifecta, [qry_breakage_combined]![Breakage] AS Break, qry_minuspool_combined.MinusPool, [qry_commission_combined]![StraightComm]-(([qry_handle_Combined]![Win]+[qry_handle_Combined]![Place]+[qry_handle_Combined]![Show]+[qry_handle_Combined]![Quinella]+[qry_handle_Combined]![DailyDouble]+[qry_handle_Combined]![Perfecta]+[qry_handle_Combined]![Pick3]+[qry_handle_Combined]![Superfecta]+[qry_handle_Combined]![Trifecta])*[StateTaxRate]![Rate]) AS SComm, [qry_commission_combined]![GimComm] AS GComm, [qry_commission_combined]![ExComm] AS EComm, [qry_surcharge_combined]![Surcharge] AS ILSUR, qry_surchbreak.DimeBreak, qry_commission_combined.StraightComm, qry_commission_combined.GimComm, qry_commission_combined.ExComm, qry_payout_combined.SumOfSumOfPayout, qry_netpool_combined.SumOfSumOfNetPool
FROM StateTaxRate INNER JOIN ((qry_payout_combined INNER JOIN (qry_netpool_combined INNER JOIN ((qry_commission_combined INNER JOIN (ToteHost RIGHT JOIN (ToteLocation RIGHT JOIN (qry_surcharge_combined INNER JOIN (qry_minuspool_combined INNER JOIN (qry_breakage_combined INNER JOIN qry_handle_Combined ON (qry_breakage_combined.Meet = qry_handle_Combined.Meet) AND (qry_breakage_combined.Date = qry_handle_Combined.Date) AND (qry_breakage_combined.Program = qry_handle_Combined.Program) AND (qry_breakage_combined.Source = qry_handle_Combined.Source) AND (qry_breakage_combined.Community = qry_handle_Combined.Community)) ON (qry_minuspool_combined.Meet = qry_handle_Combined.Meet) AND (qry_minuspool_combined.Date = qry_handle_Combined.Date) AND (qry_minuspool_combined.Program = qry_handle_Combined.Program) AND (qry_minuspool_combined.Source = qry_handle_Combined.Source) AND (qry_minuspool_combined.Community = qry_handle_Combined.Community)) ON (qry_surcharge_combined.Meet = qry_handle_Combined.Meet) AND (qry_surcharge_combined.Date = qry_handle_Combined.Date) AND (qry_surcharge_combined.Program = qry_handle_Combined.Program) AND (qry_surcharge_combined.Source = qry_handle_Combined.Source) AND (qry_surcharge_combined.Community = qry_handle_Combined.Community)) ON ToteLocation.Source = qry_handle_Combined.Source) ON ToteHost.Program = qry_handle_Combined.Program) ON (qry_commission_combined.Meet = qry_handle_Combined.Meet) AND (qry_commission_combined.Date = qry_handle_Combined.Date) AND (qry_commission_combined.Program = qry_handle_Combined.Program) AND (qry_commission_combined.Source = qry_handle_Combined.Source) AND (qry_commission_combined.Community = qry_handle_Combined.Community)) LEFT JOIN Tracktype ON (qry_handle_Combined.Meet = Tracktype.Meet) AND (qry_handle_Combined.Program = Tracktype.Program)) ON (qry_netpool_combined.Meet = qry_handle_Combined.Meet) AND (qry_netpool_combined.Date = qry_handle_Combined.Date) AND (qry_netpool_combined.Program = qry_handle_Combined.Program) AND (qry_netpool_combined.Source = qry_handle_Combined.Source) AND (qry_netpool_combined.Community = qry_handle_Combined.Community)) ON (qry_payout_combined.Meet = qry_handle_Combined.Meet) AND (qry_payout_combined.Date = qry_handle_Combined.Date) AND (qry_payout_combined.Program = qry_handle_Combined.Program) AND (qry_payout_combined.Source = qry_handle_Combined.Source) AND (qry_payout_combined.Community = qry_handle_Combined.Community)) INNER JOIN qry_surchbreak ON (qry_surchbreak.Meet = qry_handle_Combined.Meet) AND (qry_handle_Combined.Date = qry_surchbreak.Date) AND (qry_handle_Combined.Program = qry_surchbreak.Program) AND (qry_handle_Combined.Source = qry_surchbreak.Source) AND (qry_handle_Combined.Community = qry_surchbreak.Community)) ON StateTaxRate.SourceID = qry_handle_Combined.Source
WHERE (((qry_handle_Combined.Date) Between [StateTaxRate]![BDate] And [StateTaxRate]![EDate]) AND ((qry_handle_Combined.Source)="ATB" Or (qry_handle_Combined.Source)="CBD" Or (qry_handle_Combined.Source)="EFF" Or (qry_handle_Combined.Source)="FAR" Or (qry_handle_Combined.Source)="GVL" Or (qry_handle_Combined.Source)="QUY" Or (qry_handle_Combined.Source)="SPF" Or (qry_handle_Combined.Source)="AI" Or (qry_handle_Combined.Source)="WK" Or (qry_handle_Combined.Source)="QC" Or (qry_handle_Combined.Source)="RF" Or (qry_handle_Combined.Source)="MB" Or (qry_handle_Combined.Source)="SAU" Or (qry_handle_Combined.Source)="EG" Or (qry_handle_Combined.Source)="MC" Or (qry_handle_Combined.Source)="SB" Or (qry_handle_Combined.Source)="LP" Or (qry_handle_Combined.Source)="HW" Or (qry_handle_Combined.Source)="HK" Or (qry_handle_Combined.Source)="SD" Or (qry_handle_Combined.Source)="VP"));