I have a simple ms access database. I need help to create an invoice function within the database.
The table named "time-log-worked-for-various-organizations_tbl" contains a log which is imported monthly from an excel worksheet. This contains records for when, where and what job was performed for what customer and how much pay was aggreed for each job done.
I need a form where I can select a customer, start and end date from the log, and this information should pull the information from the log and generate an invoice.
The invoice itself should contain information that you will find in the design view of the "invoice_tbl"
I will also need a table and a form to record received payments. Please see the table "Payments-received_tbl" for this.
Then at last, I will need a report that can retrieve a list of balances (outstanding payments and payments received) in order to keep track of any unpaid invoices.
I tried to do this myself but I could not get it to work.
Please see the uploaded database. It contains dummy data. When your work is completed, I intend to copy and paste the forms/macros/tables..etc into my real live database.
35 freelancers are bidding on average $167 for this job
Hi, I am interested. I have considerable expertise in the design and development of MS Access databases. I would be happy to discuss about your requirement. Regards.