Sql Problem......

[chiuso2]

Hi there,
I made a form based on a query.
The form contains 2 fields, Name and Address.
Into the query's field "Name" condiction i wrote:Iif(IsNull(Forms!Form1!Name;"*";forms!form1!name)
I would like to see all the Names if Forms!Form1!Name Is null, but it doesn't work.
It works if i write like "*", directly into the query...
but i need to do it from the form!!
Thanks in advance for any suggestion...and sorry for my bad
English.
Mario from Italy

 

[chrisaroundtown]

Try this:

IIf(IsNull(Forms!Form1!Name),"*",forms!form1!name)

Let me know if it works.
Thanks

 

[chiuso2]

Hi chrismerry..
Thanks for your suggestion..but it doesn't work.
I already Tryied the same solution.....
Mario