I am a beginner and new to this forum, need help to create form and report.
My task is to create database with forms and reports, where, we open New Jobs and each jobs remains with us for 1 year. Same times, we invoice it on monthly basis where we maintain the every day stock reporting for it coupled with outstanding sheet where all unpaid invoices shall be shown.
I have already created a Database with the name of "tblMucMainDB" and a form with the name of "frmMucJob" to fetch the data for each job along with a field name Service Charges which I shall use for Billing....
Now ,I need to generate monthly invoices/bills (Reports) for each job along with stock reports on daily basis and I don't know how may I do this...
In next step, I will be needing an outstanding sheet where all unpaid data would be shown..
If any one help me, I will highly appreciate it and will be very thankful...
My task is to create database with forms and reports, where, we open New Jobs and each jobs remains with us for 1 year. Same times, we invoice it on monthly basis where we maintain the every day stock reporting for it coupled with outstanding sheet where all unpaid invoices shall be shown.
I have already created a Database with the name of "tblMucMainDB" and a form with the name of "frmMucJob" to fetch the data for each job along with a field name Service Charges which I shall use for Billing....
Now ,I need to generate monthly invoices/bills (Reports) for each job along with stock reports on daily basis and I don't know how may I do this...
In next step, I will be needing an outstanding sheet where all unpaid data would be shown..
If any one help me, I will highly appreciate it and will be very thankful...