This is a multi-part message in MIME format.



------=_NextPart_000_006B_01C0C4E9.90C30D60

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable





Hi there,

I am developing an accounts package based on the Northwind template and 

I want to add a facility for printing statements at the end of each 

month.



I am wondering what is the conventional approach to this type of 

project.

Receipts,

create a new table for receipts?

Credit notes,

Create a table for credit notes or put them in as negative entries in 

the order details table?

Statements,

How would I create a query to list all transactions for each customer 

from two or three tables ('order details', 'credit notes' and 

'receipts') or is this possible?



Regards

Oliver Dempsey