Choosing a special criteria

[Safwany]

I want to use a special criteria in some field with something like " IF THEN
" function, for example, If [form]![employees details]![country]="USA" THEN
preview all the countries list.

I think that MS ACCESS does not have the IF THEN function, what is the
alternative and how to use?

 

[John Spencer (MVP)]

I'm not sure what your question is.

Access has an IIF function that can be used in queries.

So in a query you could use something like the following for a calculated
field. A trivial example of using that would be:

Field: ShowNothing: IIF([Field A] is Null,"Nothing There",[Field A])

You can also use VBA and create custom functions.

In criteria you can use something like the following. It will find exact
country matches unless USA is the value in [form]![employees
details]![country]. In that case it will find all records where country has a
value. It will not find records where country is Null

Field: Country
Criteria: Like IIF([form]![employees details]![country]="USA", "*",
[form]![employees details]![country])

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County