Can someone Please Assst with this issue?
I created a form that pulls records from a compensation qry this stores information that pulls from two tables EmpStats and Compensation Rate Table. These two Tables are joined on the EMP ID. When I pull up my Compensation form I need to see information from my records which shows
EmpID, Name, Begin Work Exp, Pay Rate etc I need to create a combo box that lets me select the name of the employee and will automatically fill the record with the employee I choose. Instead it only pulls up the lName field and adds that as a new record to the Compensation Qry! I also need to creata a field on my form that will allow me to calculate from the date of Begin Work Experience the total number in Years of Experience they have. Any suggestions? Thanks In advance for a Quick Response!!
I created a form that pulls records from a compensation qry this stores information that pulls from two tables EmpStats and Compensation Rate Table. These two Tables are joined on the EMP ID. When I pull up my Compensation form I need to see information from my records which shows
EmpID, Name, Begin Work Exp, Pay Rate etc I need to create a combo box that lets me select the name of the employee and will automatically fill the record with the employee I choose. Instead it only pulls up the lName field and adds that as a new record to the Compensation Qry! I also need to creata a field on my form that will allow me to calculate from the date of Begin Work Experience the total number in Years of Experience they have. Any suggestions? Thanks In advance for a Quick Response!!
Last edited:
