Login

Connect
Sign in using Facebook

Access update query problem

No replies
shakeelmscw's picture
shakeelmscw
Offline
Newbie
Joined: Feb 15 2012

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?