Append using date

[Terri]

I need some assisance.

I have a number of tasks tracked per shift that I would like created for
each day and shift.

I am struggling with how to do use the insert into to create these. I am
trying to work with:

INSERT INTO qrytblTasks (TaskID, Task)
SELECT qrytblTasks.LeftTaskID, FROM qryleftdutyshifttasks

I am using the default date() in the main task table to populate the date
field.

I would greatly appreciate any assistance!

 

[KARL DEWEY]

What kind of problem are you having?
I see that you did not select a field to insert into Task.

 

[KARL DEWEY]

Missed another - SELECT qrytblTasks.LeftTaskID indicates it is pulled from
qrytblTasks and not from qryleftdutyshifttasks.

 

[Larry Linson]

You are appending two Fields, but your SQL only references one, and there is
an extraneous comma between the SELECT clause and the FROM clause. Unless
there is an unobvious connection that we are supposed to make, your comment
regarding "the date field" also appears extraneous as there is no field that
is _obviously_ a date field.

Larry Linson
Microsoft Office Access MVP