need help with INSERT statement

[dharkangel]

Hi everyone,

I have this series of statements here:

INSERT INTO 1_2_06 ( Issue_ID, Assigned_To)
SELECT Issue_ID, Assigned_To
FROM QPTActions
WHERE QPTActions.Entry_Date<=DateValue('1/2/2006') And QPTActions.Close_Date>DateValue('1/2/2006');

and it works fine but I would like to insert another value into a third column called 'ListType'. It would be a hardcoded value like this "QPT". How would I correctly add this to the statment I have now?

Thank you

 

[carp]

INSERT INTO 1_2_06 ( Issue_ID, Assigned_To, ListType)
SELECT Issue_ID, Assigned_To, 'QPT'
FROM QPTActions
WHERE QPTActions.Entry_Date<=DateValue('1/2/2006') And QPTActions.Close_Date>DateValue('1/2/2006');

 

[dharkangel]

Awesome, sometimes the solution is so easy...

thank you