Search results for query: *

Thanks Olaf Abbasaif

Perfect!! I got it. Thanks Abbasaif

Hi How can I extract numberic digits from a Alphanumeric field as shown in image. I want to extract it and generate the index on it. Thanks Saif

Thanks for the time sharing for this issue. Abbasaif

Sorry Mike, Actually I don't want the value less than 1.00 and not greater than -0.99. Regards Abbasaif

Hi, Thanks for the reply! I tried this and got it Select agreport Set Order To cref1 Do Case Case This.Parent.chkValue.Value = 1 SET FILTER TO !(totday < 1.00 AND totday > -0.99) Otherwise Set Filter To Endcase Go Top Note: I want the value which should be greater than 1.00...

Hi, It should be less than 1.00 and greater than -0.99. Thanks Abbasaif

Hi How can I filter the amount between 0.01 to 0.99 and -0.10 to -0.99. Thanks Abbasaif

Hi, I want to calculate time difference in minutes as follows: a=DATETIME() && {13/01/2020 02:38:15PM} b={13/01/2020 02:19:15PM} c=a-b The answer is 20 minutes, and the value of "c" is 1116. Please suggest. Thanks Abbassaif

Please check the link for excel file. Thanks Abbassaif Link

Thanks Mr. Mike for the reply! No, No I want to attach that excel file which is shown in image, just to check the formula for your reference and which I want to apply in my program. Can I derived it from SQL Syntax. Thanks Abbassaif

Hi, How can I calculate the moving average value of a particular item which purchased multiple times. Please let me have some idea how to calculate the figure in Red. The Arrow mark shows the field name. Thanks Abbassaif I want to attach excel file. How can I do so?

Thank Mr. Olaf for this detail explanation with examples. Definitely I will go through this. With warm Regards Abbassaif

Thanks Mr. Olaf I will use this instead of: mJono = 'JO118214' mRollno = 'RO'+subs(mJono,3,8)+'A' Only in printing section, "JO118214" is mandatory. We have to use it just to create the Roll No. and then in the rest entire process "Roll No." will be used. The Record will not be deleted...

Great Mike [thanks] Yes cString = LEFT(nNew, 8) + CHR(65 + totrec) Exactly I was looking for that I don't want increment in numeric field ("RO"+118214+"C"), it is fixed. Only the last letter which is from "A to Z" The length I want to keep it 15 character. Because this is first stage. I...

Hi Thanks Mr.Mike, I applied that command, like; nNew='RO118214B' TOTREC=2 cString = "RO" + PADL(nNew, 15, "0") + CHR(65 + totrec) Result is showing cString = 'RO000000RO118214BC' I want cString = 'RO118214C' Regards Abbassaif

Hi, I did something like this: mJono = This.Parent.txtJono.Value Select tmpRoll Count To totrec Do Case Case totrec = 0 mRollno = 'RO'+Substr(mJono,3,8)+'A' Case totrec = 1 mRollno = 'RO'+Substr(mJono,3,8)+'B' Case totrec = 2 mRollno = 'RO'+Substr(mJono,3,8)+'C'...

Hi, The Value of the final letter must be in sequence not random. Regards Abbassaif

Sorry, I forgot to attach Image. Regards Abbassaif

Thanks Mr.Mike for the reply. I usually do the same which you explained. But it is slightly different case. It is character field in the last. And, I want to generate A,B,C,D and so on... Regards Abbassaif