Access update query problem
If i use a select query with these codes, it works perfect.
SELECT Fee_Account.Billing_months.Value, Fee_Account.Student_class, Fee_Account.DueDate
FROM Fee_Account
WHERE (((Fee_Account.Student_class)=[Forms]![studentfeeadd]![Student_class]) AND ((Fee_Account.DueDate)=[forms]![studentfeeadd]![duedate]));
but when i change this query to update query it shows zero records to update while in select query it shows 3 records (which is correct).
Here are the codes for update query which is showing zero record to update.
UPDATE Fee_Account SET Fee_Account.Billing_months.[Value] = [forms]![studentfeeadd]![Billing_monthss]
WHERE (((Fee_Account.Student_class)=[Forms]![studentfeeadd]![Student_class]) AND ((Fee_Account.DueDate)=[forms]![studentfeeadd]![duedate]));
Can someone help me to trace out the problem in this update coding?