This is the program description: ---------------------------------------------------------- I need a program that has 3 tables and 3 forms and 1 report: TABLES: 1 clients - with 4 columns: id, last name, first name, type 2 products - with 4 columns: id, name, price 3 shopping - with 4 columns: id, date, client ID, Product ID, quantity FORMS: 1 Clients - Enter clients according to table 2 Products - Enter Products according to table 3 Shopping - entering shopping of products according to the products in the products table (choosing from droplist) same for client (droplist). REPORT: Choosing a client will present a report that shows dates, products, quantity and prices. according to the customer type it will also show a discount price and show totals in the bottom of the report.------------------------------------------------------------------------- What I need from you is the REPORT part: I need to have reports by date and by Client. The reports should calculate the total purchases and discount according to client type. Get back to me if you're interested by PM.