Search results for query: *

SkipVought, we can't seem to get on the same page here. I don't see how I could explain this any clearer than I already have; so rather than waste any more of our time I'm going to keep having a go at this on my own. Thanks for looking, Andrew

The user does not enter row 3, it's a database grouping field for the items in row 4. The other values in row 3 aren't relevant, I only care when the value is 2 or 3. If the activity code was in row 37, i would want the loop to continue as it did with each other activity code Maybe I should...

Hi Andy, correct that is what my Excel data looks like. For each row, i want to sum the values that have a row 3 column header = 2. So in my example of activity code HC9200006, I would like to sum the 30 from column C and the 5 from column D. Ideally, i would like to hold that 35 in a...

I would appreciate some help with this project. Using VBA: for each row in the below table, I would like to create a variable of the sum of certain columns based on the value in row 3. For example: activity code HC9200006, if the column header in row 3 is a '2', i want to sum those values...

Thanks SkipVought! That worked great.. appreciated

With this code nothing is being hidden. So for example, Cell N10 is NULL (so it meets my 1st "Hide" criteria), and N15 is "AGENCY" (so it meets my 2nd "Hide" criteria). Yet column N remains visible after running my code. Does that help?

Can someone please tell me what I am doing wrong? I want to hide columns based on the values found in 2 different cells, but I can't seem to get it right. Below is my current attempt... thanks for looking. Sub Hide0DollarColumns() Dim GLvalue As String Dim RVU As String For Each r In...

Thanks mintjulep! this is what ended up working for me... appreciate the help! Dim objTask As Object Set objTask = ActiveInspector.CurrentItem Dim objProperty As Outlook.UserProperty Set objProperty = objTask.UserProperties.Add("Priority ", Outlook.OlUserPropertyType.olText) Dim...

This is what I have so far... I'm trying to run it from a button in a new task window. It produces an error "Object variable or With block variable not set". I'm new to macros... please be kind :) Sub taskUserPriority() Dim objTask As Outlook.TaskItem Dim Priority As String Priority =...

Selected as the active item... I would like to create a new task, and from that window hit a macro button to assign user-defined priority

I have a user-defined property in my Outlook Tasks called "Priority". When I create a new task, I would like to have a button that calls a macro where I can input my custom priority (1, 2, 3, etc...). I think I need to use .UserProperties("Priority"), but I'm having trouble setting the macro...

I have a payroll table that holds dollars by month and hours by month as columns, like so... Employee | Hours1 | Hours2 | Hours3 | ... | Dollars1 | Dollars2 | Dollars3 | Andrew | 40 | 40 | 45 | ... | 1000 | 1000 | 1500 | I would like to unpivot this data to display...

Sure! All the data is in the same table... in this sample, 'PatientAccount' 456 and 789 are "Professional" accounts linked to "Hospital" account 123456789. Patient Account HB Match Charges Payments DischargeDate 123456789 NULL 100 80 7/1/2013 987654321...

We have a field in our database 'PatientAccount' where the value can represent either a "Hospital" account or a "Professional" account. One or more "Professional" accounts can be linked to a single "Hospital" account, which is defined in a separate field 'HB Match'. What I would like to do is...

I'm trying to write a manual running total formula in a Subreport to get a Year-to-Date value for each 'Cost Center' that I can pass to the Main report. Below is what I have so far, and it works OK except in the case where the Main Report has a 'Cost Center' value that does not exist on the...

I'm looking for suggestions on how to exclude records from summaries and crosstabs based on another summary field. We have a lot of scenarios where a cost center will post a charge incorrectly onto a patient's record, which is then subsequently reversed. The initial post & reversal exist on...

Both solutions worked beautifully... thank you, very appreciated! Andrew

Hi, I'm using Crystal Reports 2008. I have data that looks like the table below. What I'm trying to do: for every like 'Guarantor', I would like to create a formula field to tag each 'Source' = "PROFESSIONAL" account with the associated 'Source' = "HOSPITAL" account. I've tired using a "DO"...