Conditional Statements in Criteria (using ODBC Tables)

[erin.tpt]

I am looking for some help to solve an issue with duplicates being pulled from the ODBC tables that I am using. Just as some background, our database has the option for multiple salutation codes on a single account. Not all of the accounts that I need to pull have the preferred salutation that I need.



The end product that I would like to show is:

IF "Preferred" exists, show that salutation,
if "Preferred" does not exist, show "default".

At the moment, I am getting the default for all accounts and duplicates for those with a preferred salutation using this statement:

=IIf([SALUTATION_CODE]="PREFERRED","PREFERRED","DEFAULT")

[orange]

You are close. The syntax is generally correct.

But [Salutation_Code] is a field name
"PREFERRED" is a value

I don't think you really want "PREFERRED" as a salutation.

What are the fields in your table?

I can foresee a situation like this.
Let's say that the default_Salutation for the run is "Mr."

The Contact table has a field called preferred_Salutation.
For Conatct_Number 123 let's say the value of preferred_Salutation is "Ms"
For Conatct_Number 200 let's say there is no value in preferred_Salutation

So using
iif(Len(Preferred_Salutation) >0,Preferred_Salutation, Default_Salutation)
123 will have Ms
200 will have Mr.

All this is saying is
if there is a preferred_Salutation, then use it
if there is no preferred_Salutation, then use the default.

Good luck


PS - I don't see where ODBC has anything to do with this