C ctr1085 Registered User. Local time Today, 14:01 Joined Jul 7, 2006 Messages 26 Jul 10, 2006 #1 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.
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.
N namliam The Mailman - AWF VIP Local time Today, 23:01 Joined Aug 11, 2003 Messages 11,695 Jul 12, 2006 #2 Currentdb.Querydefs("Queryname").SQL will give you your current sql of that query and you can change that SQL as well.... Currentdb.Querydefs("Queryname").SQL = "Select ... from .... where"
Currentdb.Querydefs("Queryname").SQL will give you your current sql of that query and you can change that SQL as well.... Currentdb.Querydefs("Queryname").SQL = "Select ... from .... where"
C ctr1085 Registered User. Local time Today, 14:01 Joined Jul 7, 2006 Messages 26 Jul 12, 2006 #3 Thanks for the info.
