Null and Non null

[pleg12345]

Hi, im producing a user input search criteria.

For the initial criteria i used the like operator:
Like "*" & [parameter]& "*"

However.. This does not return Null values in other fields

For e.g. I have a custname field which always contains data
I also have a feedback field which in some cases may be null.

I resolved the problem by entering the following in the feedback criteria:
(Like [parameter] & "*&quot Or Null

However i now have another problem.....
When i do a search on the feedback criteria, it will bring up both null and non null records. I obviously just want it to display the users stated criteria.


Can somebody please help

 

[MakeItSo]

Just had a wild thought:
Have a go with
(Like [parameter] & "*&quot Or [parameter]

If the parameter is Null, it's the same as before.
But if it isn't, Null values would be excluded. ;-)

Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[pleg12345]

Unfortunately that doesnt bring up null values when entering a different criteria!

im tearing my hair out with this ! ha ha

 

[Norris68]

Could you use the NZ function on your field?

e.g.
... WHERE NZ(MyField,"&quot LIKE [Parameter] & "*"