CODEWITHSUNDEEP
ms-access
Ibrahim Hassan
Ibrahim Hassan

Reputation: 59

MS Access single character cells

In MS ACCESS is there is a way to discard records with only single character in a field, the cell have just A, or just b tried * and got all records, tried ? and got nothing Thanks

Upvotes: 1

Views: 44

Answers (1)

S Huff
S Huff

Reputation: 116

You can use the LEN function in a query to say you only want the items of a given field greater then 1.

Select *
From TableName
Where LEN([FieldName]) > 1

Upvotes: 2

Related Questions