Solved Set Criteria to show records with numbers ending with ... (1 Viewer)

[Number11]

Hi,

So how would i go about having a query criteria to only show records that have a field with numbers that end with 0000000 (7 zeros at the end of the number in a field)

 

[arnelgp]

select field1, [morefields] from yourtable where [field] like "*0000000"

 

[Pat Hartman]

Sounds more like the field is a code than a number. Just because something has only numeric characters doesn't mean it is actually numeric. My master card account # is 16 numeric characters but isn't actually a "number".

If parts of a field mean something, then they shouldn't be mushed together.

arnel's solution is fine for what you asked. Just be aware the it precludes the use of any index so if your table is large, the query could be clunky.