G
Guest
All worked fine until we added this table to form. Now cannot even delete
table and get form to work correctly.
Here is SQL statement from form's record source:
SELECT tblSalary.*, tblEmployee.*, tblSalary.PayRatioMemo,
qselFullName.[Full Name], qselFullName.SocialSecurity, tblSalary.[Benefit
Notation], tblHRInsurance.InsurancePercent, tblHRInsurance.InsDesc
FROM tblTimeOff INNER JOIN (((tblEmployee INNER JOIN qselFullName ON
tblEmployee.SocialSecurity = qselFullName.SocialSecurity) INNER JOIN
tblHRInsurance ON tblEmployee.SocialSecurity = tblHRInsurance.EmployeeId)
INNER JOIN tblSalary ON tblEmployee.SocialSecurity = tblSalary.EmployeeID) ON
tblTimeOff.TimeOffID = tblSalary.TimeOffID;
Let me know if more information is needed.
table and get form to work correctly.
Here is SQL statement from form's record source:
SELECT tblSalary.*, tblEmployee.*, tblSalary.PayRatioMemo,
qselFullName.[Full Name], qselFullName.SocialSecurity, tblSalary.[Benefit
Notation], tblHRInsurance.InsurancePercent, tblHRInsurance.InsDesc
FROM tblTimeOff INNER JOIN (((tblEmployee INNER JOIN qselFullName ON
tblEmployee.SocialSecurity = qselFullName.SocialSecurity) INNER JOIN
tblHRInsurance ON tblEmployee.SocialSecurity = tblHRInsurance.EmployeeId)
INNER JOIN tblSalary ON tblEmployee.SocialSecurity = tblSalary.EmployeeID) ON
tblTimeOff.TimeOffID = tblSalary.TimeOffID;
Let me know if more information is needed.