Passthrough Query filtering

Program: Microsoft Access – Data on Informix Server • SQL Search A split form with 4 textboxes. These textboxes will filter the below SQL code. o Two textboxes for informix.whs_order.pick_date will be for the date between ranges (highlighted below) o One textbox for informix.whs_order_pick.pick_item_nbr (highlighted below) o One textbox for informix.whs_order.store_nbr (highlighted below) Once these boxes are filled in I would like a search button to execute the modified code showing the results within the splitform. The two date options must have a value before launching the code. The other two can run with blanks and with search as * so choosing all values in those fields. • I would also like a button to export the results to a new empty spreadsheet in excel. With my very limited knowledge I would assume a connection string may be required if done though vba which will be provided if needed. Following pass-through SQL Code select informix.whs_order.whs_order_nbr, informix.whs_order.store_nbr, informix.whs_order.pick_date, informix.whs_order_pick.orig_ord_line_nbr, informix.whs_order.shipment_nbr, informix.whs_order.invoice_nbr, informix.dispatch_unit.dispatch_unit_id, informix.dispatch_unit.disp_unit_stat_cd, informix.dispatch_unit.load_seq_nbr, informix.dc_load.est_dispatch_ts, informix.whs_order_pick.pick_item_nbr, SUM (informix.whs_order_pick.actual_pick_qty) Pick_Qty, informix.whs_order_pick.whpk_sell_amt, SUM (informix.whs_order_pick.order_qty) Case_Qty, SUM ((informix.whs_order_pick.actual_pick_qty * informix.whs_order_pick.whpk_sell_amt ))Total_Cost from informix.dc_load, informix.dispatch_unit, informix.whs_order_pick, informix.whs_order where ((informix.whs_order.pick_date BETWEEN {d '2017-11-09'} and {d '2017-12-12'}) and (informix.whs_order_pick.pick_item_nbr IN (1252157))and (informix.whs_order.store_nbr IN (4566))) and informix.whs_order.wms_order_id = informix.whs_order_pick.wms_order_id and informix.dispatch_unit.wms_dsptch_unit_id = informix.whs_order_pick.wms_dsptch_unit_id and informix.whs_order.wms_load_id = informix.dc_load.wms_load_id group by 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13 order by 2, 6 ;