I have the following working sql clause:
SELECT [order details].ProductID, Sum([order details].cartons) AS
SumOfcartons, Sum([order details].Quantity) AS SumOfQuantity,
customers.Customerid, customers.CompanyName, products.Productid,
products.grade, orders.paymentid, orders.orderid, customers.afid,
Sum(([Order Details].[UnitPrice]*[Quantity])) AS ExtendedPrice
FROM products INNER JOIN ((customers INNER JOIN orders ON
customers.Customerid = orders.customerid) INNER JOIN [order details] ON
orders.orderid = [order details].OrderID) ON products.Productid =
[order details].ProductID
GROUP BY [order details].ProductID, customers.Customerid,
customers.CompanyName, products.Productid, products.grade,
orders.paymentid, orders.orderid, customers.afid
HAVING (((customers.Customerid) Not In (118,120)) AND
((orders.paymentid)=0));
I have made the following constant:
Public Const strNotIn = ” Not In (118;120))”
Then i tried to replace it in the sql so:
SELECT [order details].[ProductID], Sum([order details].[cartons]) AS
SumOfcartons, Sum([order details].[Quantity]) AS SumOfQuantity,
[customers].[Customerid], [customers].[CompanyName],
.[Productid],
.[grade], [orders].[paymentid],
[orders].[orderid], [customers].[afid], Sum(([Order
Details].[UnitPrice]*[Quantity])) AS ExtendedPrice
FROM products INNER JOIN ((customers INNER JOIN orders ON
[customers].[Customerid]=[orders].[customerid]) INNER JOIN [order
details] ON [orders].[orderid]=[order details].[OrderID]) ON
.[Productid]=[order details].[ProductID]
GROUP BY [order details].[ProductID], [customers].[Customerid],
[customers].[CompanyName],
.[Productid],
.[grade],
[orders].[paymentid], [orders].[orderid], [customers].[afid]
HAVING (((customers.Customerid)=strNotIN) AND ((orders.paymentid)=0));
I received an error message Extra ) in query expression
‘(((Customers.Customerid)=strNotIn)) AND ((orders.paymentid) = 0));
I cannot find the extra ) i have written in my expression.Also in the
sql query i receive the message enter parameter value.
Where are the extras in my code?I will be grateful for any help
