code check pllease

[Jen0dorf]

Hi



I have 35000 records and I have a field designated

Yearofbaptism. The field is formatted text and contains records such as the following

1856
1856/57

I want to create a query that will only show the records with 5 characters or more.

I created the following sql but it does not do what I want

SELECT tbl_Baptism.YearOfBaptism, tbl_Baptism.FullDateOfBaptism
FROM tbl_Baptism
WHERE ((("len [yearofbaptism]")>"5"));

Where have I gone wrong?

thanks

Ian

[ranman256]

in the query:

field: LEN([yearofbaptism])
criteria >5


...WHERE (((Len([yearofbaptism]))>5));

[June7]

Perhaps you need >= operator.

[Jen0dorf]

Thanks that was it

IAn

in the query:

field: LEN([yearofbaptism])
criteria >5


...WHERE (((Len([yearofbaptism]))>5));