Peo,
I'm trying to use this formula, but can't seem to make it right.
is A1 the field where the query input is?
If it is, then I'm missing something else.
fyi, I would rather not use macro, if we can get this by using a
formula.