J
Jeff Fox
I have a database that lists checks by date in numerical sequence. Some of
the checks are voided. Voided checks are listed with the letter "v" in
front of the number. When attempting to filter the database to copy to
another location the "v" checks show up in the filtered output. I tried
using a formula to filter out any checks that start with a "v". For
example, in the criteria range I inserted the formula =+AB8>=54119. The
formula shows checks that start with the letter v return as true? Why?
Shouldn't a letter be viewed as text? To make matters worse the formula
returns nothing in the output range.
Any suggestions? I'm very familiar with formulas in Criteria ranges but
this one is a puzzler.
the checks are voided. Voided checks are listed with the letter "v" in
front of the number. When attempting to filter the database to copy to
another location the "v" checks show up in the filtered output. I tried
using a formula to filter out any checks that start with a "v". For
example, in the criteria range I inserted the formula =+AB8>=54119. The
formula shows checks that start with the letter v return as true? Why?
Shouldn't a letter be viewed as text? To make matters worse the formula
returns nothing in the output range.
Any suggestions? I'm very familiar with formulas in Criteria ranges but
this one is a puzzler.