Return records greater than 3 characters

  • Thread starter Thread starter mate
  • Start date Start date
M

mate

How do run a query that returns any records that are
greater than 3 characters long? Any help is greatly
appreciated. thanks, mate
 
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
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top