Creating customer invoices or statements

[gnome76]

I'm trying to create an Access database for my small business, and have made some inroads, but am finding it challenging to finish things off so that it can do all the things I want it to do.

I have tables for Customers, products, orders, returns and campaign number (I do Avon which is based on a different brochure every three weeks).

I have customers who order more than one product per campaign, and can't work out how to create one statement/invoice that I can then send to them.

I've downloaded the time/billing template from microsoft, but honestly, it is simply too daunting. I've next to no knowledge of SQL, and if I can get away with not having to learn too much that would be great.

Any suggestions (in laymans terms please!) would be greatly appreciated.

 

[speakers_86]

Can you upload what you have so far? Also, what is the significance of the campaign? Wont the product number stay the same regardless of the campaign? I'm not sure the campaign should affect the design of your database. Perhaps you could elaborate.

 

[John Big Booty]

Welcome to the forum.

Have you considered using one of the off the shelf accounting packages. It will potentially save you a lot of time and heartache in the long term.

 

[Rabbie]

A p;iece of friendly advice. Sit down with some paper and a pencil and work out how you would produce the invoices if you didn't have a computer. Once you get a clear idea of the process involved you will be able to see how you can implement the solution in Access. This process will also let you know which info you need for each invoice so you can check that you have a suitable data structure.

If then you are unsure on how to do specific things in Access then post the question in the relevant section of this forum and we will do our best to help