I am interested in creating a field in query based on the values in
existing fields. If the value in field A = 'Y' then insert value in
field B, else do nothing. I get syntax errors, but nothing that is
helpful to correct the 'error'.




--
troestj