Find only records up to 40 characters

D

Dimitris

In a field There are entries with many characters. How can I filter only the
records which have up to 40 characters?
Thanks
Jimmy
 
R

Rick Brandt

Dimitris said:
In a field There are entries with many characters. How can I filter
only the records which have up to 40 characters?
Thanks
Jimmy
Click to expand...

SELECT *
FROM TableName
WHERE Len(FieldName) < 41
 
D

Dimitris

Thanks Brandt.
Since I am new in Access, where exactly am I going to write that code?
Jimmy
 
R

Rick Brandt

Dimitris said:
Thanks Brandt.
Since I am new in Access, where exactly am I going to write that code?
Jimmy
Click to expand...

That's not code. It's the SQL of a query. Just paste it into SQL view of a
new query (substituting your table and field names) and then switch to
design view.
 
Top