Passthrough Query filtering

£20-250 GBP

Imekamilika

Imechapishwa

over 6 years ago

£20-250 GBP

Kulipwa wakati wa kufikishwa

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 ;

Kitambulisho cha mradi: 15891232

Kuhusu mradi

6 mapendekezo

Mradi wa mbali

Inatumika 6 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

Imetolewa kwa:

@arranmercer

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 ndani ya siku 1

5.0

(6 hakiki)

3.6

6 wafanyakazi huru wana zabuni kwa wastani £59 GBP kwa kazi hii

@VladimirLilenko

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!

£50 GBP ndani ya siku 1

4.9

(66 hakiki)

5.6

@iglobalvn

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,

£100 GBP ndani ya siku 1

4.9

(9 hakiki)

5.4

@alaeddindhahri

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.

£38 GBP ndani ya siku 0

5.0

(50 hakiki)

5.3

@nirmalsarswat

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

£111 GBP ndani ya siku 2