Search results for query: *

Remou, Thank you it works, don't know why I didn't realize that.

Diamond 3250027 Zero will be in odd position althought it is an even number. I am picking up numbers from the odd postions from right.

Yes. The number would be 7053

Zion, PHV, Diamond How would you hadle a zero inside the string. Say 3250027 the code completely skips as it is equal to 0 Rekha

Zion & Remou, Thank you both for helping me. It worked like a charm. Thank you both again for helping me

Hi everyone, Below is my code to go and pick all the even number from right. But I am not able to do it .Bar TotalOdd will be 57 But I want to get 75. Could you look at the code & help me figure out where I should modify my code. I tried right function but not able to get it. Any...

cLFlaVA Still didn't work. Any other ides!!

Hi Everyone, I have 2 dropdown box where one of the drop down box should be hidden when the a button is clicked. This is what I have so far <TR> <TD WIDTH="50%">Diagnosis4:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SELECT NAME="cmbDiag4" size="1" ID= "cmbDiag4"> <option>A </Option>...

Can you explain furture if you don't mind. I am new to this Thank you

How do you automate running of a vbs file? Any help is appreciated. Right now I run it through command prompt using cscript Thank you

Hi everyone, I have to launch crystal report using access97 using ODBC connection. I have no idea how to do it. Could you point me in the right direction Thank you RR

Hi everyone, CR 7.0 SQL 2000 I have 2 table appt & docdesc link on account number and adate to svvdate left outer join link. In docdesc you have desction as 'patient letter', 'Patient notes', prescriptions, E& M Family Med. I want to display all the results from appts table whether there...

Hi Everyone, CR 7.0 SQLServer 2000 I have a very strange problem. I have 2 table appts & Char The link is left outer join to Account#. What i want is even if no records are in char I still want to see records from Appts table. Under the EditselectionForumula->Group I have set if char.Desc <>...

LB Okay will give it a try. Thank you very much Rekha

LB, FamilyID will not always be the same length only the last 2 number will be 01 02 etc. Also I made a mistake her 1008 should be 2 e.g. 100701,1000801,100802, 100901,100902,100903 1007- FamSize 1 1008- 2 1009 3 I am sorry, but I don't understand how you are counting...

K, I have to do this based on the Familyid which is e.g. 100701,1000801,100802, 100901,100902,100903 1007- FamSize 1 1008- 1 Example output FamSize 1 2 3 4 5 6 60 70 35 25 15 10 I hope I have explained or shown you what I want to do . Please guide me as...

Version 7.0 Server 2000 sQL server In the databsase field called Familyid where the family members are grouped togeterh so that whent the reassignemtn are made they are all assigned to the same Residents. Eg F01223401 F01223402 F01223403 F01223404 I have grouped them by Familyid by...

Hi Everyone, Crystal Version 7.0 SQL Server 2000 Tables CLproblem Appointments Joining on account numbers from appoiuntmetn to clproblem. I am seeing whoever came to the clinic how many had dx of 250, 401. I have 2 group one for Account number and other for Dx. I have to dispaly all the...

SQL server 2000 How can I replace commas if the commas are in between Ex I & D, COMPLEX/MULTIPLE CLOSED RX, RADIAL/ULNAR S TREATMENT OF FINGER FX, E Any suggestions Thank you in advance Rekha

Bob, I used the sql statment to delete the record. It worked Thank you RR