append query

[gaba]

Hi,
I've used to have this query in Access and when I transfer the database to
an Access project/MSDE Server I cannot find out how to make the "AS
NewOrderID" work...

INSERT INTO [Order Details] ( Forms!Orders.Tag, ProductID, UnitPrice,
Quantity, Discount, OrderID )
SELECT [Order Details].OrderID, [Order Details].ProductID, [Order
Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount,
CLng(Forms!Orders!OrderID) AS NewOrderID
FROM [Order Details];

Thanks in advance