If you have an ethnicity column I want to go to the next column and for all
of a certain ethnicity I want to return either a 1 or a zero.

Column A Column B
Hispanic 1
White 0
African American 0

In this case I am just quering for one ethnicity to which the second column
would display a1 for yes and or a 0 for no.

Any suggestions.