If statement..... Possible Match

From: "learning_codes@xxxxxxxxxxx" <learning_codes@xxxxxxxxxxx>
Date: 25 Mar 2007 08:01:18 -0700

Hi,

I'm trying to make two fields that are similar.

I create but it won't give me the result.

FieldA : Baseball
FieldB: Baseb
Possible Match: Yes

FieldA: Football
FieldB: Football
Possible Match: Yes

FieldA: Baseball
FieldB: Football
Possible Match: NO

Please help me if I did the right or not. Your help would be much
appreciated.

Possible Match: IIF([FieldA] like [FieldB],"Yes","NO")

Thanks

.

Follow-Ups:
- Re: If statement..... Possible Match
  - From: Michael Gramelspacher
- Re: If statement..... Possible Match
  - From: Tom Lake
- Re: If statement..... Possible Match
  - From: Tom Lake
- Re: If statement..... Possible Match
  - From: John W . Vinson
- Re: If statement..... Possible Match
  - From: Marshall Barton

Prev by Date: Re: Date Criteria Correct?
Next by Date: Macro trouble
Previous by thread: Date Criteria Correct?
Next by thread: Re: If statement..... Possible Match
Index(es):
- Date
- Thread

Relevant Pages

Re: If statement..... Possible Match
... FieldA: Baseball ... FieldA: Football ... FieldB: Football ...
(microsoft.public.access.queries)
Re: If statement..... Possible Match
... FieldA: Baseball ... FieldA: Football ... FieldB: Football ...
(microsoft.public.access.queries)
Re: If statement..... Possible Match
... FieldA: Baseball ... FieldB: Football ... Two strings are similar in this example, ...
(microsoft.public.access.queries)
Re: insert variables into Query
... Learning SQL and Access ... from tableX ... fieldA <= tableY.EndDate ... fieldB>= tableY.EndDate ...
(microsoft.public.access.queries)
Re: constraint in Trigger
... CREATE TRIGGER tiu_name ON tblName ... IF (@FieldB IS NOT NULL) AND (@FieldA IS NULL) ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(comp.databases.ms-sqlserver)