hi.. if u r using sql server u have t facility to make query. t thing u hav to do is to select t tables link t tables and pick t fields. t query is ready Rgrds Ageesh

Stylus VB wrote: i have to create my data file to temp location then i gotta zip it. this means 400 mb hdd space instead of 200 mb. if i could give a path like this C:\file.zipx\data.ktt file will be directly saved under that. Let us assume for a moment that you managed to do what you are trying to do with a simple File.Move("C:\Data.ktt", "C:\YourContainerFile.cnt\Data.ktt"). Here is what would actually happen: 1. C:\Data.ktt (disc usage 200 mb) 2. Copying Data.ktt to C:\YourContainerFile.cnt\ (disc usage 400 mb) 3. Deleting C:\Data.ktt (disc usage 200 mb again.) You can create the zip file at run time, and write to it at run time. In the end you would use your system memory and hdd space to the exact same extent. Think about it, what you are trying to accomplish in the end is a file containing another file. Or in other words, you want a folder that acts like a file. That is exactly what a zip file is. My advice is free, and you may get what you paid for.