8 Solved Topics

Remove Filter
Member Avatar for
Member Avatar for elouch

how can i paste result from excel formula to value or even store the result into a string below codes does not seem to works... For x = 2 To rowcount worksheet2.Range("B" & x).Value = worksheet2.Range("D" & x).Text worksheet2.Range("C" & x).Value = worksheet2.Range("E" & x).Text Next worksheet2.Range("C" & x).Value = …

Member Avatar for fourty
0
1K
Member Avatar for cyberdaemon

Good day, I am having troulbe with my computation here. i want to compute for the Custom_Haulage_In_Transit but when i exec my sp the value of the Custom_Haulage_In_Transit is 0. can anyone help me with this please.. here is my code SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant …

Member Avatar for adam_k
0
214
Member Avatar for cyberdaemon

Good day, I am having a probem with my sql. I want to create a formula for my pivot field.. here is my code... SELECT * FROM ( SELECT REPORT.MATERIAL ,REPORT.Description ,REPORT.Material_Type ,REPORT.ATP_check ,REPORT.Delivering_Plant ,REPORT.Order_Quantity ,REPORT.Held_by_Finance ,REPORT.Rejected_OOS ,REPORT.Rejected_Others ,REPORT.Open_Order_Quantity ,REPORT.Order_Quantity_NKA ,REPORT.Order_Quantity_RKA ,REPORT.Order_Quantity_Others ,REPORT.Stock ,REPORT.DSD_Delivery ,REPORT.OUtBound_Haulage ,REPORT.Total_OutBound_items ,REPORT.InBound_Haulage ,REPORT.Haulage_In_Transit ,REPORT.Process_Order ,REPORT.Total_Inbound_Items …

Member Avatar for cyberdaemon
0
209
Member Avatar for jonsan32

I have a site for youth basketball, where parents can list their kid to get them onto a team. The listings that get replied to by teams needing players are deleted, but some listing remain on there for months or years. To combat the potential confusion of which grade a …

Member Avatar for EvolutionFallen
0
223
Member Avatar for azareth

i have this code where it computes for the time entered by the user. it doesn't have yet the limitations or the conditions regarding the time to be entered . it successfully computes for the time and the hour increases based on the minutes, but the problem is when you …

Member Avatar for TrustyTony
0
259
Member Avatar for apals

MY problem is related to entry of research data. The researchformula is entered into a textbox alongwith other usual form entries like title,subject,startdate etc. The formula consists of alzebra, trignometric, otherfunctions etc. Example [CODE] [B]x = 12; y = 24 + tit[x] + mixer[x]; z = x + sin(x) + …

Member Avatar for apals
0
236
Member Avatar for haka007

Hello Members, Would anyone please take a look at my attached excel files which is a commodity exchange's end of the day data file. This is a free copy which anyone can download from their websites. Those are ([url]www.mcxindia.com[/url]) & ([url]www.ncdex.com[/url]). Now my query is in those two files there …

Member Avatar for haka007
0
279
Member Avatar for jonsan32

I've searched a while, can't find this... I'm looking for a way to present two choices for values, then to have a result immediately appear based on those choice. IE... The first choice is an option between 1, 2, 3, 4, or 5 players... and the second choice is an …

Member Avatar for jonsan32
0
215

The End.