Display All if Input Left Blank 1

[XMalvolio]

In my query, the user must input which company he wishes to view information for or leave the field blank to view all.

Here's what I'm working with:

=IIf(IsNull([Input]),{CODE TO DISPLAY ALL RECORDS},[Input])

I checked the code and if I make the true value one of the company names, it works perfectly. Only I can't seem to figure out how to tell it in the true value to display data from all companies. Any ideas? Thanks in advance for your help

 

[PHV]

=[Input] Or [input] Is Null

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244