Editing Records in table

[Mustakrakish]

Hi everybody,

I am new in access and this is problem i have not been able to solve with queries or with other simple solution.

I have table with 8000+ records and few fields. I need to edit all records in one field with 2 different values according to second field (if Field 1 = 0 then set field 2 Alternative 1 else Alternative 2)

I have experiences with excel vba but access is much more complex.

I do not know if it is better to do this with VBA procedure or with macro, but I tried macro (that macro builder) but i have not been successful.

I have access 2010

Thanks for your help

 

[Addyman]

Can you not just run two update queries?

Query 1: Set the criteria for Field 1 to equal 0 and then update Field 2 to Alternative 1.

Query 2: Set the criteria for Field 1 to <> 0, and then update Field 2 to Alternative 2.

Unless I'm missing something?