Expression not working

hudaz

Registered User.
Local time
Today, 14:46
Joined
Jan 22, 2013
Messages
28
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
 
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]
 
Last edited:
Where are you using the expression
 

Users who are viewing this thread

Back
Top Bottom