Does anyone know how to manipulate a saved query? I want to change the select statement with code so that my pivot table will use the new records. Any information would be appreciated.
What exactly are you doing? You may not want to handle it this way. There are nice benefits to leaving the SQL alone (it speeds up data retrieval). A filter could better suit your needs.
