Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ajhess
  • Content: Threads
  • Order by date
  1. ajhess

    Summing row values conditionally by column headers

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

    Conditionally Hiding Columns in Excel

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

    VBA - Editing a UserDefined Property in an Outlook Task

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

    UNPIVOT on 2 columns

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

    Make 2 passes at a table in 1 query

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

    Manual running total formula

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

    Exclude records based on summary field in group

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

    Using Do Loops?

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

Part and Inventory Search

Back
Top