Set Value in Sql of Query

[klynch0803]

In the below sql statement within my query how can I set the invadjust in the first line to true when this is ran?

INSERT INTO tdatInventoryRec ( RecDate, Item, Qty, invadjust )
SELECT [qdatInventoryCheckupGather Diff].InvDate, [qdatInventoryCheckupGather Diff].Item, [qdatInventoryCheckupGather Diff].Converted
FROM [qdatInventoryCheckupGather Diff]
WHERE ((([qdatInventoryCheckupGather Diff].Diff)<0));

 

[pbaldy]

Add

, True

to the SELECT clause. Is this thread a continuation of the other, so I shouldn't bother following up there?