Hi All

Thanks for the many comments

I have a purpose built POS application, the mentioned payment types are fixed

Admittedly the multiple payment type option is probably excessive, but I have encountered...

Hi all

Thanks for the replies, most appreciated that you take the time

I don't think the table design is wrong

InvoiceNo int,

PaymentDate datetime,

PaymentAmount money

Cash Money

CC Money

Cheque Money etc

As payments for a transaction...

Hi Jeff / Sergie

Thanks for the replies

I should have been more specific with my problem

The above examples work fine but only return the data as 1 record

To graph the payment...

Hi jeff

Just a grand total for the range

Regards

Steve