Dear Matt:
Create a calculated column. This is done by labelling a column and
putting in the formula. I'd suggest:
ColWidth: LEN(YourColumn)
Substitute the actual name of your column where I have put YourColumn.
Now run the query. You should see the width of each row as entered.
Place this next to a query column that shows the actual values in that
column so you can see if it works exactly as you wanted.
Next, add a criteria ">3" in this new column. That's it!
How do run a query that returns any records that are
greater than 3 characters long? Any help is greatly
appreciated. thanks, mate
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
