Hi,
I'm using following query to Insert Values into tblSalary bit values are not being inserted and get error similar to unable to Insert values for to conversion failure.
Datasheet View of the query show chinese (possibly) characters in month and year fields. I've tried everything I can think of but nothing worked. Db is attached. Can you please help me fix this issue?
Best Regards
Abdullah
I'm using following query to Insert Values into tblSalary bit values are not being inserted and get error similar to unable to Insert values for to conversion failure.
SQL:
INSERT INTO tblSalary ( TeacherID, PayMonth, PayYear )
SELECT DISTINCT tblTeachers.TeacherID AS Expr1, Forms![frmSalary]!txtMonth AS expMonth, Forms![frmSalary]!txtYear AS expYear
FROM tblTeachers;
Datasheet View of the query show chinese (possibly) characters in month and year fields. I've tried everything I can think of but nothing worked. Db is attached. Can you please help me fix this issue?
Best Regards
Abdullah