General Question

S

shadow

Fields are text.


By defalt I want the value in field two which is in the secondary table
to display the word "TAG" when Field 1 in the main table has a value of
"NA" see below for example

For example


Field 1 is the main table and field 2 is in the secondary table. Both
are tied in a query.


Field 1 Field 2
Test
NA Tag
NA Tag
Test
NA Tag

Notice everytime an "NA" value in field 1 (main table) the value "Tag"
is atomatically displayed in Field 2 (secondary table).

How can I make this happen in my query that ties the main to the
secondary table.

Tks

Joe
 
Top