Query with empty fields

[valterduarte]

I have a table field with the following records:

Table A
aaaaa
bbbbb
(empty field)
ccccc


I want to run a parameter query that returns all the records when I leave the Parameter box empty. It's something like this:

Like IIF([Parameter A] is Null,"*",[Parameter A])

However, when I run it and leave the Parameter field empty, it returns only:

aaaaa
bbbbb
ccccc

The empty record is not included!! How do I solve this?

Thank you!

 

[dhookom]

Assuming your field name is MyField, consider using something like:
[MyField] & "" Like Nz([Parameter A],"*")

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[valterduarte]

It's not working...

 

[dhookom]

If you want additional assistance you should take the time to tell us why you think it's not working.

Also, please provide us with the complete SQL view of your query.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

And what about this in the criteria cell:
Like [Parameter A] OR [Parameter A] Is Null

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

 

[lynchg]

Maybe the parameter field isn't null, but just empty. Try:

Len(Trim(ParameterA)) = 0