I am currently stacking a querry on top of another querry so when i execute querry #2 it runs querry #1 to form data to be used in Querry #2 then it runs querry #2 with fresh data. What i reaaly want to do is hve querry #1 create a table (#1). Then when i execute querry #2 it goes out and runs querry #1 to rebuild table #1 then querry #2 then runs extracting data from the refreshed table #1. is this possible and how, or am i making something too hard. i do have a purpose for this, have data in a cube and want the cube updated befor querry #2 runs thanks GRT