Recordset is not updateable

[khoatkit]

Querry:
ID
Date
CustomerID
ProductID
Size
.............
Table:
CustomerID
ProductID
Size
StartDate
EndDate
Discount
SQL
SELECT Querry.ID, Querry.Date, Querry.CustomerID, Querry.ProductID, Querry.Size, Table.Discount,......
FROM Querry LEFT JOIN Table ON (Querry.ProductID = Table.ProductID) AND (Querry.CustomerID = Table.CustomerID) AND (Querry.Size = Table.Size) AND (Querry.Date >= Table.StartDate) AND (Querry.Date <= Table.EndDate);
Specific Customer will get a discount in Price for Specific Product and Size, for Specicific period, there can be

 

[khoatkit]

there can be multiple periods for a customer, period 1 customer 1 will get discount 1, period 2 customer 1 will get discount 2
With this SQL I get the correct result, but Query is not updateable, would you please show me the way to do this
-----
Continue previous post

 

[xenou]

Hi,
see:
Microsoft Access tips: Why is my query read-only?
This Recordset is not updateable: Dealing with non-updateable queries in Microsoft Access
Roger's Access Blog: This Recordset Is Not Updateable. Why?

and others (google "msaccess query is not updateable")