Hi All

In a form, I create a table by reading in a spreadsheet.


Next I need to update a column( "Event") in the table by reading column "Solution" and checking "Solution" for certain values. Depending on the values found in Solution, which is a string, Event is set to different values.

For example if I find the words "GWIP" and "Install" in the Solution column then I set Event = "GWIP Installations"
ELSEIF I find the word "DCos" in the Solution column then I set Event = "Programming Changes" and so forth.

I understanjd how to update a table in SQL, but not how to write the loop functionality and update the table in Access. I want to be able to do this by having the user clicking on one command button.

Please help

Thanks in advance