ASAP MS Access DB Fix and Custom Report / VBA
4944
£10.0k(approx. $12.5k)
- Posted:
- Proposals: 7
- Remote
- #37493
- Archived
Description
Experience Level: Expert
I have this Access Database that needs cleaned up. Extremely time sensitive.... like three hours from time of posting. Need someone to start ASAP. Database is already made, i just need the following:
1. Have a single report • at the top you have a drop down box for location And it automatically generates a report of profit/loss. With a TOTAL bar at the bottom showing the weekly total revenue. I currently have a report with revenue, and a report of expenses. I would rather not have my DB flooded with all these seperate reports and just have one consolidated one. My VBA skills cant handle this part.
4. In the payments received table you will see values self populate when you change the contract ID.
a. We need to change the view of that from contract number to include the client name.
b. Need to make it run an update sql query to update commission_expense table. This will store our commission values be that need to be included in expenses.
This shouldnt take that long, just a few fixes.
Also bonus points if you can modify my entire database to connect to a remote MS SQL server of which i have not being used atm. However not required and i need to have this database to calculate this information within 3 hours or i am screwed.
bah, it wont let me upload my database. If you are interested bid, and ill send you the DB bc its over 1mb
1. Have a single report • at the top you have a drop down box for location And it automatically generates a report of profit/loss. With a TOTAL bar at the bottom showing the weekly total revenue. I currently have a report with revenue, and a report of expenses. I would rather not have my DB flooded with all these seperate reports and just have one consolidated one. My VBA skills cant handle this part.
4. In the payments received table you will see values self populate when you change the contract ID.
a. We need to change the view of that from contract number to include the client name.
b. Need to make it run an update sql query to update commission_expense table. This will store our commission values be that need to be included in expenses.
This shouldnt take that long, just a few fixes.
Also bonus points if you can modify my entire database to connect to a remote MS SQL server of which i have not being used atm. However not required and i need to have this database to calculate this information within 3 hours or i am screwed.
bah, it wont let me upload my database. If you are interested bid, and ill send you the DB bc its over 1mb
Randy N.
0% (0)Projects Completed
5
Freelancers worked with
5
Projects awarded
29%
Last project
7 Nov 2011
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies