Recent content by wtkaufmann

Would code go into the query that creates my form? OR Should I use a query Pivot Table instead of a form Pivot Table? I am a little confused, any more direction you could give would be great

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

Does it have to do with the "acEdit" in the DoComd Line???

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

Thanks Brian... Looks like this will work

Some of the fields do have the #num! That is part of my problem... But the excel fields do not have spaces, they are just blank fields surronded by fields wih dates... Hence why I am trying to query the dated records out of the table with LIKE */*/####. The problem is I can only run the...

Still get an error... Even tried - LIKE "*/*/????" Again works when I save the query in Design View and click DataSheet view, However if I close the query and reopen in DataSheet view the error is present. Any other thoughts???

wouldn't that return the results of every field that is blank? I am looking to retrieve the fields that have dates

I did take a look into that, and the support page would like me to change the data to a text format, which I would not want to do because the dates are going to used in equations later down the road... however in the field there is one of two things listed, a date in short form (mm/dd/yyyy) or...

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