Search results for query: *

select statement - I have an employee table include employee details etc and a commission table containing: commissionID, EmployeeID, CommissionAllocated, CommissionPaidOut, Date, Target. how do i set up a select statement?

I am trying to set up a query so that I can calulate commission due each monht. I then need to place this as a subform within the main employee form. How can i achive this?

Employee sales target table - i need a table that allows me to collect employees sales figures in order to work out commision. i know i need the fields: employee target, month, sales achieved, commission allocated (%), commission due. All data needs to be entered into the table via a query to...