Recent content by makeitwork09

We have SQL 2008. We were supposed to go live with SQL 2016 at the end of March. That got put on hold when we started working from home the beginning of March. I am helping to fulfill a requirement for a dated ump. One of the fields requires that we show the results formatted as 999999999999...

Thank You! Combining the union suggested by johnherman and the trim by Olaf Doschke I got it to work.

Thanks Andrezjek - I have no control over that. The database was created by the vendor. The loan column has to be unique.

I'm bit confused with the query below. Here is an example of the data set. PURGE_ACTION LOAN CLOSEOUT_STATUS PREVIOUSLOANNUM PURGE 3610878 REFINANCED PURGE 3610887 REFINANCED KEEP 3728285 REFINANCED 3610878 3610887 Note, the...

DaveInIowa - Thank You very much! That worked nicely!

I have the following set of data. It is created using a sum of principal + interest to get the payment and it is grouped by the loan number, year of as of date, and quarter of as of date. The latter two are not shown. LOAN PAYMENT 3715142 252441 3715142 252441 3715142 252441 3715142 252441...

Two years ago I posted this - http://www.tek-tips.com/viewthread.cfm?qid=1636759 With the help provided, I was able to get the report working as requested. Today, two years later, an additional group was asked to be added to report. Unfortunately, because I do not completely understand what was...

I still have no clue what was wrong with that I was originally doing, but I got this to work by using the recorded version of the code. Instead of using PivotTable1 as the name of the table, I used the name that I created. Is the the code that is working. Sub CreateRBCTopLoans() Dim...

Oh I just realized what you suggested. I do not think that is going to work.

Hi Skip, The filer is doing the top 10 values. If I were doing it manually I do the following: Click the drop-down arrow on loan_xref From the value filter choices I select Top 10 From left to right the choices are Show Top 10 Items by Statement Value (because I changed the caption from...

To get an idea of what Excel would do, I started with selecting the objects to appear in the Pivot Table. Below is what is produced. In bold is the same area that is erroring for me, even after I change my code to use Statement Value instead of Sum of Carrying Value. With...

Thanks for the reply Skip, When I used the macro recorder I got the following code for the same place where I am receiving the error in my version. ActiveSheet.PivotTables("PivotTable1").PivotFields("loan_xref").ClearAllFilters...

I am using Excel 2007 The code in bold errors with the message "Run-time error '1004 Unable to get the PivotFields property fo the PivotTable Class". If I remove the filter code complete, the pivot table is created. What is causing the filter code to error? I have tried all types of things...

I am using Windows 2007 and Excel 2007 I used the Macro recorder for a pivot table. I cleaned up most of the code to not use what Microsoft generates, but I am not sure how to clean up the code for a top 10 filter and for sorting values in descending order. Below is what the recorder generated...

I solve the problem. I had the following code after the code above. That is what was causing the information to "disappear". 'calculate the pivot table PT.ManualUpdate = False PT.ManualUpdate = True