Search results

I have dropped Dates into the column field of a Pivot Table and have it sorted by Quarters. The default is to display "Qrt 1" "Qrt 2" and so on... I would like to display the last day of the quarter.. So "Qrt 1" would equal "3/31/2010" and "Qrt 2" would show "6/30/2010" When I switch...

I am using the VBA code: Private Sub Rating_Distribution_Click() On Error GoTo Err_Rating_Distribution_Click Dim stDocName As String stDocName = "PM Rating Distribution" DoCmd.OpenQuery stDocName, acFormPivotTable, acEdit Exit_Rating_Distribution_Click: Exit Sub...

I queried a linked table with the criteria 'Is Not Null'. The table field I put criteria for has dates listed for each record and I wanted to leave out the records with no date in the field. After I save the query and run it for the first time, the query works fine. However, when I close the...