ASAP MS Access DB Fix and Custom Report / VBA

  • Posted:
  • Proposals: 7
  • Remote
  • #37493
  • Archived
Guy V.Jonathan B.Darren O.Sherif E.Singaravel R. + 2 others have already sent a proposal.
  • 1

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

New Proposal

Create an account now and send a proposal now to get this job.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.