N Number11 Member Local time Today, 20:49 Joined Jan 29, 2020 Messages 625 Mar 30, 2021 #1 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)
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 ..forever waiting... waiting for jellybean! Local time Tomorrow, 04:49 Joined May 7, 2009 Messages 20,740 Mar 30, 2021 #2 select field1, [morefields] from yourtable where [field] like "*0000000"
