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

 

[LittleSmudge]

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

Sloppy typing Mario !

Missing bracket
used ; when , needed



'ope-that-'elps.




G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.