Search results for query: *

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...

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>...

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 <>...

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

Hi Everyone, I have a combo box where the user can choose the name and click on the delete button. But whenever I do that I am using the command button wizard and every time it deletes the first records. How do I make it so that it deletes the record which is chosen in combo box? Also, how...

Hi everyone, I have to replace the strength of drugs from u to unit so that there won't be any mistakes. Data 40 u/ml 0.025 mg-1.75 mg-10000 u/ml 400 u-10 mg-3.5 mg-10000 u/gm 15 u-10 u/0.5 ml Any suggestions would be helpful. REkha

Hi Everyone, I have to update drugs table Date looks like this DRugName Strength O-Cal-D 250 mg-125 u Os Cal 500 with D 500 mg-200 iu Os-Cal with D 500 mg-125 u I have to replace u with unit and iu with internation unit. How can I write a update statment...

Hi everyone, I have 4 table master(acct)->charge->claim master(acct)->orders I have 2 links going from master one to charge and other orders. The problem is I get multiple orders how can I limit it to just 1 order or is ther a better way of handling this Rekha

Hi Everyone, cr 7.0 sql server 2000 2 table appt charge adate billdate pname account atime servicedate account cpt userid entrydate pdoc adoc I am doing a left outer join on account and adate to servicedate. There will be only one appt for the day...

Hi eveyone, CR 7.0 SQL Server 2000 Here is my dilema . 2table order charge ordate billdate cpt cpt status rdoc donedate bdoc donetime rdoc Right now I am pulling the report by orderdate. But now a sitation has come up that I have to chekc the appt...

Hi everyone cr 7.0 sql 2000 Order(t1) Billed(t2) orderdate XacDate Account account cpt cpt osdesc procdesc prov prov rdoc rdoc status dept I am doing a left outer join on orderdate and account number. I just...

Hi everyone, SQLServer 2000 cyrstal 7.0 I have to calculate the time endtime to starttime. eg. 10:01 AM 10:32 AM data type is varchar I typein {clroom.endtime} - {clroom.startime} I get an error like this a number, currency amount or date is requeired here. I just don't know how to...

Hi everyone How do I update 2 table at the same time? I have to move records from 2 table to a new acct # in the same table. The fileds are Table1 Table2 Acct Acct Docid docid idsubtype idsubtype revvalue userid Based on acct number I have to change the the acct...

Hi Everyone, CR 7.0 I have a report where I am dipslaying whethter the residents' and the prectors created notes on the patient they saw. I just want to display for an account only 2 records. If they have more than 2 records I am assuming that they have a preceptor and the attending...

Hi everyone, I have to write a reports where I have to display the account number if it does not have any matching record in the doc table. eg. appt Doc 1234 1234 04/21 04/21 23444 23444 04/21 03/21 so 23444 does not have a mathcing record in doc for the date 04/21. My...