G
Guest
Hi everyone
I've got a system where i get a job, I input the details, and set the status
of the job to "Awaiting Invoicing" when i'm done. I need to invoice my
customers each month with a proper invoice number etc.
When I get a new job, the description of the job is entered into a table
called "Jobs", and that is linked to a table called "ContentsOfJob". This
part is simple enough. What I want to do is have a report printed out for
each customer at the beginning of each month for the previous month, and be
able to track that invoice should the need arise. At the moment I don't have
any way to do it.
I'm assuming I need to create a CreateTable Query?
Cheers
Niko
I've got a system where i get a job, I input the details, and set the status
of the job to "Awaiting Invoicing" when i'm done. I need to invoice my
customers each month with a proper invoice number etc.
When I get a new job, the description of the job is entered into a table
called "Jobs", and that is linked to a table called "ContentsOfJob". This
part is simple enough. What I want to do is have a report printed out for
each customer at the beginning of each month for the previous month, and be
able to track that invoice should the need arise. At the moment I don't have
any way to do it.
I'm assuming I need to create a CreateTable Query?
Cheers
Niko