cm26508

Finding all numeric fields ending in .1

Discussion created by cm26508 on Dec 6, 2017
Latest reply on Dec 6, 2017 by globe11123

I have a, what may seem like, a pretty simple question.  I have a table that has a number field.  The decimal digit has significance.  So, I want to find all rows that have the field ending in .1 and .3.  I've tried entering the Find mode and entering the #.1 but keep getting "Duplicate Record"...???  Anyone have an answer to this easy one?

Outcomes