An If Then statement in an Access Query

[dunner44]

My criteria in my query reads...
[Forms]![frm_reports]![Text72]

Text72 is a combobox on a form, and within the list of options in the combobox is a "Veiw All" option. How would I rewrite my criteria to say, " If Text72 = 'View All' Then the criteria field should be blank to pull back all options, else criteria = Text72"

Any suggestions?

TIA.

 

[SkipVought]

Hi,
code]
IIF(Text72="View All","",Text72)
[/code]


Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[SkipVought]

IIF(Text72="View All","",Text72)

Skip,

_{[red]Be advised:[/red]
Alcohol and Calculus do not mix!
If you drink, don't derive!}

 

[dunner44]

I tried that, and it pulled back no records.
Here is what I have as my code...

IIf([Forms]![frm_reports]![Text72]="View All","",[Forms]![frm_reports]![Text72])

Am I missing something?