Expression not working

[hudaz]

Hi Everyone,

I have a query that works by looking at a form and returning the data back into a listbox, All was going well until i needed an expression that would show all if a text box was null, however if the text box was populated it would then show all the figures that were between two numbers. This is the expression i have so far...

Like IIf(IsNull([forms]![DESIGN_JOB_SEARCH]![text8]),"*",>=[Forms]![DESIGN_JOB_SEARCH]![Text41] And <=[Forms]![DESIGN_JOB_SEARCH]![Text42])

Now this works when text8 is null, however when text8 is populated it does not return any results, even though it should return several.

Could anyone advise this noob please ?


Thanks!

Andy

 

[CJ_London]

you can't create criteria like that. Try

[forms]![DESIGN_JOB_SEARCH]![text8] is null OR between [Forms]![DESIGN_JOB_SEARCH]![Text41] And [Forms]![DESIGN_JOB_SEARCH]![Text42]

 

[bob fitz]

Where are you using the expression