produce table report
hi,
how would i use a dataassist table wizard to produce a resulting table that shows how much money they have made from the sale to a client?
i have a products table which i though of inputtin a column for price however each sales advisor is on a different percentage rate for certain products. how would i implement this into the database and be able to view each salesperson rate and add it to a product for them to then view how much they have made in a table format on certain salesof products?
many thanks