Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Final_List.FP_District, Final_List.Route, Final_List.DAY, Final_List.TIME, Final_List.Product, Final_List.Distributor, Final_List.[CHECK DATE], Final_List.[% Good], Final_List.[Total OF Draw], Final_List.Subs_Check, Final_List.Subs_Y, Final_List.NOL, Final_List.[#_Skip], Final_List.[#_DND]
- FROM Final_List
- WHERE (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box])) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL)) OR (((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![day_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL)) OR (((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![time_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL)) OR (((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL)) OR (((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.Distributor)=[Forms]![Main_Form]![distributor_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.Product)=[Forms]![Main_Form]![product_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.TIME)=[Forms]![Main_Form]![time_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.DAY)=[Forms]![Main_Form]![day_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.Route)=[Forms]![Main_Form]![routes_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.FP_District)=[Forms]![Main_Form]![district_box]) AND ((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL)) OR (((Final_List.[CHECK DATE]) BETWEEN [Forms]![Main_Form]![first_date] AND [Forms]![Main_Form]![last_date]) AND ((Final_List.[% Good])<=[Forms]![Main_Form]![good_box]) AND ((Final_List.[Total OF Draw])>=[Forms]![Main_Form]![draw_box]) AND (([Forms]![Main_Form]![district_box]) IS NULL) AND (([Forms]![Main_Form]![routes_box]) IS NULL) AND (([Forms]![Main_Form]![day_box]) IS NULL) AND (([Forms]![Main_Form]![time_box]) IS NULL) AND (([Forms]![Main_Form]![product_box]) IS NULL) AND (([Forms]![Main_Form]![distributor_box]) IS NULL));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement