Rerturn all recrords if parameter is blank

[graphage]

OK, I found some solutions that are close to what I need...but not quite. The solutions I found are related to Forms and Reports.

I have a query with 2 columns. (Email Address and Date Updated)

When I run the query, I want to return any email address that is >= the specified date. If the user leaves the date paramater blank, then I would like for ALL the email addresses to be returned. I used to do this years ago at an old job, and as I recall there was a real easy criteria to use in the query to do this....but I am drawing a blank. Thanks in advance!

 

[Norie]

I use something like this as the criteria:

Like (IIf(IsNull([Enter transaction]),"*",[Enter transaction] & '*'))

It appears to work.

EDIT

So does this:

Like Nz([Enter transaction] & '*','*')

 

[graphage]

Both examples appears to work as you wrote them (thanks!)...however, I can't get the >= part of my expression to work. I thought I could just stick it in front of the parameter, but I get an error message telling me that it is typed incorrectly or too complex.

 

[Norie]

My example was for a text field for a date field you might want to change the * to a date like 01/01/1900.

eg

>=Nz([Enter date],#01/01/1900#)

I tried that against a date and it seemed to work.

When I try with the * against a date field I get the error you mentioned.