Too many IIFs

[patnick]

Hi there,
I am stuck and need some help:

T_Contacts has a column [Name] and a column [Amount]
(Name e.g. Ann-Marie; Mike Turner; Sue Horn etc.)

T_Naming has the same names in column [Naming] but sometimes written different (Ann, Mike, Sue)

As I have 30 names I try to find an other way than putting 30 IIF functions in a query to cope with the situation. In the end I would like to have [Naming] & [Amount].

Could you please help!
Many thanks in advance!

Cheers,
Patnick

 

[pbaldy]

Not really clear on what you're trying to do, but it sounds like the two tables could be joined in the query, enabling you to return the amount related to the name.

 

[c_smithwick]

Use "WHERE TableName.TextField Like '*' & SearchCriteria" - (substituting actual table name and field name of course)