I have a query from which I would like to make a table named 18H. When I run this along with some other queries as an event procedure, it does not work. If I run it manually, it works fine.
Not sure what's happening; I do have some criteria where it makes sure it picks the correct data by stating this time is between a start and end time on the other table.
Not sure what's happening; I do have some criteria where it makes sure it picks the correct data by stating this time is between a start and end time on the other table.
Code:
SELECT [SP-Pick].DDate, [SP-Pick].EmpNo, [SP-Pick].TTime, [tbl Emp Data].[Job#], [tbl Emp Data].Task, [tbl Emp Data].Start, [tbl Emp Data].End INTO 18h FROM [SP-Pick] INNER JOIN [tbl Emp Data] ON ([SP-Pick].EmpNo = [tbl Emp Data].[Emp$]) AND ([SP-Pick].DDate = [tbl Emp Data].AdjustedDate) WHERE ((([tbl Emp Data].Task) Is Not Null) AND (([tbl Emp Data].Start)<[Sp-Pick]![TTime]) AND (([tbl Emp Data].End)>[SP-Pick]![TTime]));
Comment