Update query for checkboxes

[scoe]

Hi, I hope someone can help as I am completely stumped here.
I have a temporary table that shows ID and relevant checkboxes (yes/no), checked and unchecked over a number of columns which corresponed to a main table in my database..... I am trying to update the checkboxes in the main table from the temporary table. I have checked the formating on both tables and the are the same but I cannot get the update query to work, it just checks everything....



The sql is as follows:
[UPDATE [Attendance BursHome] RIGHT JOIN [Att BursHomeRpt Temp] ON [Attendance BursHome].student_id = [Att BursHomeRpt Temp].student_id SET [Attendance BursHome].[7Paid] = [Att BursHomeRpt Temp].[7Paid], [Attendance BursHome].[8Paid] = [Att BursHomeRpt Temp].[7Paid], [Attendance BursHome].[9Paid] = [Att BursHomeRpt Temp].[7Paid], [Attendance BursHome].[10Paid] = [Att BursHomeRpt Temp].[7Paid];]

Any ideas would be much appreciated.

[lfpm062010]

It looks like you missing a where clause.

You say you have a checkboxes (yes/no).

UPDATE ...
.
.
WHERE CHECKBOXES = Yes;

[scoe]

Thank you so much, I had put the where clause in as yes but must have put it in wrong as it didn't work..... Just done it again in sql view and it's work.

Big big thank you