G
Guest
Has anyone designed an Access database to track monthly commissions for sales
people? I'd like the database to have the Customer information including
which salesperson "ownes" the account, and the products they generally
purchase from us along with default comission rates. This information I have
on an EXCEL spreadsheet. I also have on a seperate EXCEL sheet all of the
monthly sales information EXCEPT which sales person is responsible for each
sale. I have to lmanually cross reference these 2 spreadsheets each month
and, type in the sales persons name, and then in the next column type in
their commission. If Access could read my monthly EXCEL sheet and match it
with the info in the data base, it could assign each sale to the rightful
salesperson and make the commission calculation...
people? I'd like the database to have the Customer information including
which salesperson "ownes" the account, and the products they generally
purchase from us along with default comission rates. This information I have
on an EXCEL spreadsheet. I also have on a seperate EXCEL sheet all of the
monthly sales information EXCEPT which sales person is responsible for each
sale. I have to lmanually cross reference these 2 spreadsheets each month
and, type in the sales persons name, and then in the next column type in
their commission. If Access could read my monthly EXCEL sheet and match it
with the info in the data base, it could assign each sale to the rightful
salesperson and make the commission calculation...