Search results for query: *

I have an Excel 2007 worksheet where column A is a code and column B is a unit value associated with that code. Example: 02094 1.25 02095 0.00 Excel is displaying a value of 0.00 for any field with a 0 value, but the actual value being saved in the worksheet is 0, not 0.00 as it is displaying...

Hi, I've need to parse out data to identify duplicate entries in a database that share a License#, but have slightly different names. I want the results to display on a single line for each ID#. My data looks like this: Name Primary Key ID Smith,John 1...

Hi, I want to increment the value of a cell (basically a counter) each time the value "DJJ:" appears in a neighboring column. My data looks like this: COL1 COL2 DJJ: SMITH,JOHN PMF: SMITH,JOHN A DJJ: JONES,DAVEY PMF: JONES,DAVY PMF: JONES,DAVEY K DJJ: DOE,JOHN PMF: DOE,JOHN L Basically, I'm...

Hi, I have three tables all of which have names and numbers in them in corresponding rows. I want a query to match on the numbers of all three tables, while also returning the nulls in all three tables. I'm doing the comparison between the three tables because I need to know which tables need...

Hi, I've written the below code to write data from an Excel spreadsheet to a WRQ Reflections terminal. It was working fine until I tried to add a loop to it. If I use "While", it says "Wend without while". If I try to use a "For" loop, it says "Loop without For". Any ideas? Thanks...

Hi fellas, I have an interesting quandry. Because of the security profiles of my company's network, I'm not able to access (upload/write to) any files via VBA. So the only way for me to write to our computer system via VBA is for me to cut and paste the entire text file in my code. I...

Hi, I'm using the below query to try to exlude any insurance codes that start with a k or v, but it's not working. AND NOT (FinClassCurr IN('W','C','K','V') OR (LEFT(PrimaryIns,1) IN ('K','V') OR LEFT(SecondaryIns,1) IN ('K','V') Or LEFT(TertiaryIns,1) in ('K','V') OR PrimaryIns = 'M20' Or...

Hi, I'm looking to get a count of the number of rows where the first three letters of the last name in one column match the first three letters of the last name in another. I want to use the same criteria on the first name. I wrote the below formula, but it doesn't seem to be working...

I have a group of data that I need to convert to hours minutes and seconds (with leading zeros) that looks like this. 124802 12458 2365 785 96 6 I've written the following code...

Hi, I'm trying to pass a parameter in a Stored Procedure that has single quotes in it and it's kicking back an error. Here's my procedure: CREATE PROC [dbo].[uspDSHReport] @MedicaidCACClause varchar(200) AS BEGIN Declare @SQL VarChar(1000) Select @SQL = 'SELECT * INTO #KnownMedicaidNoPartB...

Hi, I have a table that looks like this: AdmitDate AcctNum 2005-03-04 5713513 2005-05-11 5713683 2005-05-18 5714069 2005-06-01 5714138 2005-06-03 5714152 2005-06-05 5714153 2005-06-05 5711825 I want to be able to count by both distinct AcctNum AND AdmitDate, because there will be...

I'm running a query to return a field "LOS" that I then want to run an aggregate Sum() function on. The problem is, I've used isnull() on both the initial query and then on the sum query and it's still coming up null. Suggestions? DROP TABLE #DishDays SELECT c.AcctNum...

Hi all, Someone loaded data into a table into the wrong column and I need to swap the data from Code into CodeDesc and from CodeDesc into Code. My table looks like this: PK HospFK Code CodeDesc 2091 1111 Self-Pay 0 2092 1111 Bad Debt A 5 2093 1111 Bad Debt NA 6 2094 1111 Bad Debt M 7 I...

Hi, I'm running the following subquery: select * into #SumDaysTemp from (select * from #SumDays join (Select Max(Acctnum) as AcctNumID,a.AcctNum, a.firstname, a.lastname, a.dob From #Sumdays a group by a.AcctNum, a.firstname, a.lastname, a.dob Having (Count(AcctNum) > 1)) B on...

Hi, I have a table in which I want to perform the following function: If StartDate <= AdmitDate then (If DischargeDate > End Date then ((EndDate - (AdmitDate + 1))) Else (DischargeDate - AdmitDate) Else If AcctNum(from Current Row) = AcctNum (from Previous Row) then...

I'm trying to write a SQL statement that when a certain criteria is met in the VBA script that it will write the current row of data to an already existing table in Access. The below statement works, but it only writes the top row of data. I need to determine what the current record is, and...

I'm running a script to our company's system using Access and VBA. Due to human error in the data I'm working with, some errors will result in the data not being inputted to the system (invalid file #'s). I've written the loop and the error handling and created a table to store the data that...

I'm working on a project to calculate turnaround times in business days. The report is sorted based on a Type column. The four types are: COMM,SEN,POS,MEDI. What I need to do is calculate the number of COMM records that took 5 business days or more to turn around and COMM records that took 6...

Hi, I've got a huge dump file from our mainframe computer that I have to fish through to find certain data. The dump file is comma delimited, but because it is effectively a dump of the code used in the system, some cells (including the cell containing the data that I want) are delimited by...

Hi, hopefully someone can help me with this. I have a spreadsheet that I keep on a commonshare network drive where I fix system issues and post them as &quot;Completed&quot; or &quot;Pending.&quot; I also color the entire row green when the item is entered to indicate that it is...