Query Conversion from Access to SQL Server

Currently we have a VB6 client server application that uses a back end Jet (Access) database. The application has 20 data reports written using the Microsoft Data Report Control. We are currently migrating the application to SQL Server and require the conversion of the commands used within these reports to now support SQL Server. Many of the commands use functions such as FormatDateTime etc. which are not supported. The selected coder will convert all these commands without any change in function to allow them to continue to operate on SQL Server and will provide some brief assistance with the last few unconverted SQL Statements that operate using Date and Time filters. ## Deliverables 1) Complete and fully-functional copy of all SQL Statements converted from the supplied originals. 2) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Microsoft Data Reports in Visual Basic 6.0 SP6 connecting to Microsoft SQL Server 2000.