Syntax error 1

[samotek]

I want to insert into the table OrdersPaid those records from the table orders, where the field paid is set to true
but i get the message too few parameters. can you help ?

Dim StrSQL As String
StrSQL = "INSERT INTO OrdersPaid (OrderID, paid) " & _
"SELECT orderid,paid FROM orders " & _
"WHERE orderspaid.orderid = orders.orderid and orders.paid = true "

CurrentDb.Execute StrSQL

 

[Remou]

The way that query is sketched, it seems that you would only insert Orders that already exist in OrdersPaid. i do not think you want to do this. I think you want to do something like this:

INSERT INTO OrdersPaid ( OrderID, paid )
SELECT orders.OrderID, orders.Paid
FROM orders
WHERE orders.OrderID Not In (Select OrderID From OrdersPaid) AND orders.Paid)="True"

Is that correct?

 

[samotek]

Thank you !

 

[Remou]

Carefully taking out the extra bracket first, of course