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!

What kind of problem are you having?
I see that you did not select a field to insert into Task.
--
KARL DEWEY
Build a little - Test a little


"Terri" wrote:

> 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!

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

--
KARL DEWEY
Build a little - Test a little


"Terri" wrote:

> 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!

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


"Terri" <starpegasus@discussions.microsoft.com> wrote in message
news:58CD80E9-B59A-4F18-8237-7015E4339348@microsoft.com...
>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!