The query I have is supposed to return data greater than 30 characters in all fields queried against.
The first field displays the data greater than 30 characters, but the other fields display data greater than 30 or less than 30. The query does not work.
Here is the query:
where (Len(regline1)> 30 or (Len(regline2)> 30) and (Len(regline3)> 30)) or (Len(regline4)> 30) or (Len(regline5)>30) or (Len(regline6)>30)))