Check record character length in Access?

[Eva_Unit_0]

I'm at work and I've been handed a ~2000 record Access database to fix. It's a database of addresses for a mailing list and the problem is that whoever made the thing to begin with didn't realize that the mailing house only allows 59 characters per field, and some of them are longer than than that. Is there a quick way to find which fields have more than 59 characters? This is on Access 2002 (Access XP, whatever).

Thanks for any help!

 

[Pwyl_The_Destroyer]

I never use access, but this sql should get you the list you want:

select * from

where len([Column]) > 59

Replacing Table and Column with the ones from your db.

I didn't test this in access, so I'm not sure if the len function is supported. (it works in sql server 2k)

 

[Eva_Unit_0]

I never use access, but this sql should get you the list you want:

select * from

where len([Column]) > 59

Replacing Table and Column with the ones from your db.

I didn't test this in access, so I'm not sure if the len function is supported. (it works in sql server 2k)

Perfect, it works great. The hardest part was figuring out how to use real SQL in access lol (I'm familiar with mysql, not access). After 20 minutes of messing around I finally figured out that I wanted to go View--->SQL View, and then I was good to go.

Thanks