D Dimitris Jun 13, 2005 #1 In a field There are entries with many characters. How can I filter only the records which have up to 40 characters? Thanks Jimmy
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 Jun 13, 2005 #2 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
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 Jun 13, 2005 #3 Thanks Brandt. Since I am new in Access, where exactly am I going to write that code? Jimmy
R Rick Brandt Jun 13, 2005 #4 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.
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.
