Hi Everyone,
I've got a really old database (customers and orders) which only has one table, but it works so i'm going to leave it as it is. I've been asked to add a query which counts how many times each customer hasn't paid for an item on time. The table is roughly as follows
RecordID (PK)
Material (txt)
DeliveryDate (Date)
Customer (txt)
OrderPaid (Yes/No)
What i'd like to do is base a report on this query which displays a list of customers and how many times they haven't paid (like below)
Customer Material Not Paid
Microsoft PC's 4
Apple Phones 3
Samsung Tablets 5
Any help greatly appreciated guys
Em
I've got a really old database (customers and orders) which only has one table, but it works so i'm going to leave it as it is. I've been asked to add a query which counts how many times each customer hasn't paid for an item on time. The table is roughly as follows
RecordID (PK)
Material (txt)
DeliveryDate (Date)
Customer (txt)
OrderPaid (Yes/No)
What i'd like to do is base a report on this query which displays a list of customers and how many times they haven't paid (like below)
Customer Material Not Paid
Microsoft PC's 4
Apple Phones 3
Samsung Tablets 5
Any help greatly appreciated guys
Em