We have 50 or 60 customers who regularly buy products from us. Currently, their customer details (names, address, telephone numbers etc) are held in a table in office access 2000 dbase, but this has no history of their purchases. Each customer buys various quantities of product A and Product B.
We want to create the following…
On the existing form, the user will enter the date and quantity of products that a customer purchases. . This needs to be stored in a separate linked table (one table for ALL customers, NOT a table for each customer, so in effect this table will have the fields Customer, Date Ordered, Qty A, Qty B)
On the existing form, a field to show the total quantity of product A and B purchased by this customer this month so far.
We need 2 reports creating. Both reports to be ran from buttons on the existing customer form.
A report per customer, which shows average qty purchased each month, total qty product purchased last year, total qty purchased this year, total qty purchased each month of the current year and each week of the current month.
A report for all customers, which shows average monthly purchase, total qty purchased this month, broke down into a week by week basis.