Hello Coders, I got 3 queries that are written in ANSI SQL..nothing comples. I need them converted to JET Sql (for MS Access) so they can be run on Access. Two of the queries are straight forward ones, this means..you convert the query...run in access get the results in a table..done. Third one also needs to be convert and run in Access but also needs some logic added to the work. How the logic works - First week the query runs, gets the data in the table. Next week the query runs again but this time when it runs...first last week's data needs to be moved to a separate table and then will be compared with this week's data. Whatever are new records in this week's run in comparison to last week is stored on a new table. This new table is to be shown as a report in Excel and as well as in standard report format. All 3 reports needs to shown as Excel and in standard report format. I have a previous verison of the 3rd report logic in Access if you want to use as a starting point. Attached is list of queries. Let me know. This project is on a deadline in 2 weeks.
## Deliverables
List of Deliverables: - All 3 ANSI queries converted to Access based Jet sqls - The conversions will be tested on my end to confirm functionality. - 3 queries to be made available as excel report and standard Access reports. - All reports to be made available in a Switchboard.
## Platform
MS Access 2000 with Excel on Windows XP