here is the senario..

I have a Form, with a Subform of the Table1 in Datasheet view.. we know that we can filter the data in the Subform.. after filtering how can i get the filtered data in the Subform to have a pivot table(form) of it.. im thinking of transfering the filtered data in the Subform into a new table.. but i dont know how..

I can solve my problem by making a lots of queries select and delete query.. but that process is too long.. i have a lots of data fields to be filtered...

can someon pleas help me on this matter...

thanks in advance!