Need Coding Suggestion for table update

[Steve_b]

Hi All:

I could use some direction in coding the following:

I have a table that has three fields that make a unique record, school, organization and year. This is what I want to accomplish

For every record in the table where year = 2011 and fieldx= "yes" locate the corresponding record for year 2012 and update fieldy = "yes"

I am not a programmer by trade but have enough Access experience to develop code with some guidance. Thanks in advance for any thoughts.

 

[Steve_b]

I ending up using a self join query which I was not aware I could do.

 

[RainLover]

You could have used an update query. Try it next time.