Thanks for the input Sylvain, I was afraid what the answer to my question might be. I was hoping for some simple solution, maybe next time. (I'll get that simple solution :) )

I have SQL Server (Small Business Server), I have even implemented some parts of my app to use it. I was just trying to avoid having to write a bunch of code. I did import my "Timecard" data into SQL Server and performed the pre-mentioned SQL Statement and It perform as VFP did on local data. I quess I'll get started on Porting that portion of my app to SQL Server. geees!

Thanks again.

>I doubt that VFP will drag all the table to the local machine. It will probably drag the index file and use it to fetch only the needed records from the table (if the query is fully optimizable).
>
>If you have a lot of data and/or you have a lot of users using your application, you may consider putting a DCOM data access layer on the server that will query the (local) database and return the results to the client in a given format (XML, ADO, etc.) All the data processing will then be done on the server and only the results will go through the wire. You need to consider the overhead of the DCOM and the packaging/unpackaging of the data that goes between the clients and the server (VFP cursor to ADO recordset on the server, ADO recordset to VFP cursor on the client, etc.)
>
>But, why try to emulate a client/server configuration when you can get the real thing? MSDE is free if you have 5 users or less. If you need more concurrent access, the time spent on emulating a client/server configuration will probably cost more than SQL Server (or Oracle, or ...) and you will have less functionalities.
>
>HTH
snip...