Find Jobs
Hire Freelancers

Access Reports to be created from ANSI Sql

$100-250 USD

Completed
Posted almost 19 years ago

$100-250 USD

Paid on delivery
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
Project ID: 3761091

About the project

6 proposals
Remote project
Active 19 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$62.47 USD in 5 days
4.9 (82 reviews)
5.5
5.5
6 freelancers are bidding on average $123 USD for this job
User Avatar
See private message.
$148.75 USD in 5 days
5.0 (129 reviews)
7.8
7.8
User Avatar
See private message.
$212.50 USD in 5 days
4.8 (355 reviews)
6.5
6.5
User Avatar
See private message.
$157.25 USD in 5 days
4.8 (12 reviews)
4.5
4.5
User Avatar
See private message.
$157.25 USD in 5 days
5.0 (6 reviews)
1.1
1.1
User Avatar
See private message.
$85 USD in 5 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$127.50 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
7
Member since Jun 11, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.