Using a formula

[Rodrigo Borges]

I have a table named tserver of a list of servers (only one field). My query
consults another table named tAllServers that have lot of server and I need
to build a field that check if the server located in tAllServers is in
tServer as well. If ok, this field need to be populated with "yes", if not,
"Not".

 

[John W. Vinson]

On Tue, 29 May 2007 19:40:01 -0700, Rodrigo Borges <Rodrigo

I have a table named tserver of a list of servers (only one field). My query
consults another table named tAllServers that have lot of server and I need
to build a field that check if the server located in tAllServers is in
tServer as well. If ok, this field need to be populated with "yes", if not,
"Not".

Create a Query joining tserver to tAllServers by the server name field. Select
the Join line in the query design window and select Option 2 (or 3) - "Show
all records in tAllServers and matching records in tServer".

Select the server name in tServer into one field in the query grid; in the
other type

IIf(IsNull([tAllServers].[yourfieldname]), "Not", "Yes")

John W. Vinson [MVP]