IIF statement in query

[RaulDR]

Hi All,

This criteria should return all record if the parameter is null or the user
just press enter. But it's not working please help.

IIf([Enter Area Code:] Is Null,"Is not Null",[Enter Area Code:])

TIA

 

[Gina Whipp]

RaulDR,

Try...

Like [Enter Area Code OR Press Enter for All] & "*"

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[RaulDR]

Hi Gina,

it worked! thanks!

RaulDR,

Try...

Like [Enter Area Code OR Press Enter for All] & "*"

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All,

This criteria should return all record if the parameter is null or the
user
just press enter. But it's not working please help.

IIf([Enter Area Code:] Is Null,"Is not Null",[Enter Area Code:])

TIA

 

[John W. Vinson]

Hi All,

This criteria should return all record if the parameter is null or the user
just press enter. But it's not working please help.

IIf([Enter Area Code:] Is Null,"Is not Null",[Enter Area Code:])

TIA

That will search for the literal text string "Is not Null" - and I doubt any
area codes match that.

Gina's suggestion will work; a bit better (since it doesn't depend on
wildcards) is

[Enter area code:] OR [Enter area code:] IS NULL

 

[RaulDR]

Thanks John!

Hi All,

This criteria should return all record if the parameter is null or the user
just press enter. But it's not working please help.

IIf([Enter Area Code:] Is Null,"Is not Null",[Enter Area Code:])

TIA

That will search for the literal text string "Is not Null" - and I doubt any
area codes match that.

Gina's suggestion will work; a bit better (since it doesn't depend on
wildcards) is

[Enter area code:] OR [Enter area code:] IS NULL

 

[Gina Whipp]

You're welcome!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina,

it worked! thanks!

RaulDR,

Try...

Like [Enter Area Code OR Press Enter for All] & "*"

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All,

This criteria should return all record if the parameter is null or the
user
just press enter. But it's not working please help.

IIf([Enter Area Code:] Is Null,"Is not Null",[Enter Area Code:])

TIA

 

[Gina Whipp]

John,

I USED to use that until I discovered typos!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi All,

This criteria should return all record if the parameter is null or the
user
just press enter. But it's not working please help.

IIf([Enter Area Code:] Is Null,"Is not Null",[Enter Area Code:])

TIA

That will search for the literal text string "Is not Null" - and I doubt
any
area codes match that.

Gina's suggestion will work; a bit better (since it doesn't depend on
wildcards) is

[Enter area code:] OR [Enter area code:] IS NULL

 

[John W. Vinson]

John,

I USED to use that until I discovered typos!

Hwat do typoes hav to do with it? <g>