delete records with < 24 chars?

[Jacare]

Very simply, I need to delete any row who's column "Name" had under 24
characters in it (including a space).

Any hints?

[T Martin]

I'm assuming the records that you want to delete are in a table already in
your Access database.

Create a delete query. create a new field in the query with the formula
len([name]) and in the criteria use <24 and when you run the query it will
delete all records that is less than 24.

"Jacare" <ja****@compcsu.co.edu> wrote in message
news:95*******************@63.240.76.16...

Very simply, I need to delete any row who's column "Name" had under 24
characters in it (including a space).

Any hints?

[Rick Brandt]

"Jacare" <ja****@compcsu.co.edu> wrote in message
news:95*******************@63.240.76.16...

Very simply, I need to delete any row who's column "Name" had under 24
characters in it (including a space).

Any hints?

DELETE TableName.* FROM TableName
WHERE Len([Name]) < 24
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com