1 Attachment(s)
How to filter out rows in a certain column by number of characters?
For safety I colored the rows in my picture, but you can call the columns whatever you like:
Attachment 160803
It happens that we import data into the Access table from Excel and some of the columns which should be formatted with 4 character places, contain only data in 3 places.
Without scrolling to the bottom of the table, how can I filter out rows in a certain column which contain less or more characters then the needed number of characters?
In this case rows with 3 chars, and it should be with 4.
Re: How to filter out rows in a certain column by number of characters?
probably the easiest is to read the worksheet as a recorset, with an sql query
Re: How to filter out rows in a certain column by number of characters?
Code:
SELECT *
FROM tablename
WHERE LEN(tablename.fieldname) <> 4