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 ;
Hello Mate,
Nice to see another Uk freelancer!
This can be done easily by either linking the query through the the 4 text boxes, or by having a button run some VBA code to alter the pasted SQL code.
I am a certified Microsoft Office Specialist who works daily with Excel, Access & SQL.
Please let me know if you have any questions!
Thanks,
Arran
£30 GBP за 1 день
5,0 (6 відгуки(-ів))
3,6
3,6
6 фрілансерів(-и) готові виконати цю роботу у середньому за £59 GBP
Hello, dear sir!
I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality!
From the Access, of course, familiar.
Give me a chance to show what I can do!
Hi sir,
I have read your requirement carefully.
I am interested to work for this project and i will provide complete Passthrough Query filtering within or before 10 hours .
If you wanna confirm me, please check my work history and portfolio kindly. Then, you can know about my ability that can do your project enough. Especially, this is my experienced and successful work before
Of course, I know you could be in doubt about my real ability. It would be important for me to prove my ability through real project. I hope this project would be the first step in long term partnership with you. I await your favorable reply with interest. I feel confident my execution of this order will be to your complete satisfaction. I ready to start right now . Please feel free to ask any questions and we would be happy to assist you. Regards,
Hi, I'm a professional VBA developer. I have solid experience with multiple search criteria, I can show examples where I used more that 12 controls for filter. I also know how to export your results, no need for connection string.
Let me know if you're interested in my services.
Your documentation is good, I am developing .net, PHP web apps from last 2 years and have sense of MSSql tools and all. Your query need a bit modification I think but all the way I can do. So initiate a chat to get more about me and if negotiation then also