Hello fellow viewers,

I would like to include a numeric field in a view filter.

However, when I do, and then bind that view to a query-by-example form, the numeric field cannot be null. This works fine as long as the user uses the numeric value to do the lookup, but what if he doesn't?

If I set the .value of the field to "", I get a data type mismatch.

Has anyone done this successfully? If so, how?

TIA,
Dan