IIf syntax for Null and Return All 1

[southbean]

Hello All,

It seems simple enough but I can’t seem to get the syntax to work. This is what I’m trying to do:

I have a form with a text field in which a user can either leave blank or enter a number. This will be used in a query criteria. If left blank return all records. If populated, then return all greater than the value.

>[Forms]![frm_Parameters]![GreatThanAmt] Or Like “*”

This is a currency data type field in an Access 2007 database.

Thank in advance for Any/All suggestions!

- tl

 

[dhookom]

Try

>[Forms]![frm_Parameters]![GreatThanAmt] Or [Forms]![frm_Parameters]![GreatThanAmt] Is Null

Duane
Hook'D on Access
MS Access MVP

 

[southbean]

Bingo!

Thanks, dhookom!

- tl