P
Please Help
Hello all,
I have a number field in my append query. Instead of hard coated the
criteria with the formula "<>0" on that field, I want to make it to prompt
the user for a value when the query is ran. I tried the formula:
Not Like nz([Please enter a value for exclusion],"*")
That formula does not seem to work.
Please help.
Thanks.
I have a number field in my append query. Instead of hard coated the
criteria with the formula "<>0" on that field, I want to make it to prompt
the user for a value when the query is ran. I tried the formula:
Not Like nz([Please enter a value for exclusion],"*")
That formula does not seem to work.
Please help.
Thanks.