R
Robnauticus
Guest
Hello all nice to see you again,
I am having a problem creating an append query to populate multiple records from input on a form. The field on the form is a date field.
To sum it up, the user will type in the date and click the commit button that runs the query. The query will take that date and create a record for each task in a list (separate table).
I created an 3 expressions that point to the fields on the form to append to the key fields and date field in the completed tasks table.
Please feel free to take a look at the DB I have attached to see what I am trying to do.
Any leads on where to check for problems would be appreciated.
Thanks
Rob
I am having a problem creating an append query to populate multiple records from input on a form. The field on the form is a date field.
To sum it up, the user will type in the date and click the commit button that runs the query. The query will take that date and create a record for each task in a list (separate table).
I created an 3 expressions that point to the fields on the form to append to the key fields and date field in the completed tasks table.
Code:
PARAMETERS Forms![NewJobSetup]![JDE Number] Long, Forms![NewJobSetup]![JDE Division Code] Text ( 255 ), Forms![NewJobSetup]![DateCommitted] DateTime;
INSERT INTO CompletionLog ( [JDE Number], [JDE Division Code], TaskName, DateComplete )
SELECT [Forms]![NewJobSetup]![JDE Number] AS Expr1, [Forms]![NewJobSetup]![JDE Division Code] AS Expr2, [MasterTaskList]![ID] AS Expr3, [Forms]![NewJobSetup]![DateCommitted] AS Expr4
FROM MasterTaskList INNER JOIN (JobTable INNER JOIN CompletionLog ON (JobTable.[JDE Number] = CompletionLog.[JDE Number]) AND (JobTable.[JDE Division Code] = CompletionLog.[JDE Division Code])) ON MasterTaskList.ID = CompletionLog.TaskName;
Please feel free to take a look at the DB I have attached to see what I am trying to do.
Any leads on where to check for problems would be appreciated.
Thanks
Rob