Field Length Qry (finding records with X amout of characters or more)

[Dano]

I'm doing a database merge, but the one of my merge fields from the old database was set longer than the new one.

Does anyone know what criteria I could use in my old database to run a query that would find any records that have more than a certain amount of characters in a field so that I can clean it up before doing the merge.

For example. I'd like to find anyone from the old table whose name is more than 30 characters or so? I'm thinking it'd be something like this (Like "##############################*") But I'm not sure if that's the right way to do it.

ANy help is greatly appreciated. Thanks!

 

[KenHigg]

if len(myfeild) >=30


???
kh

 

[Dano]

Thanks

I'll try that.. thanks!

 

[Dano]

That didn't work? Any other Ideas?

 

[KenHigg]

Where and how did you use it?

kh

 

[Dano]

I created a new query in design mode. Showed the Cust Table and dragged the Name and ID fields into the botton area then in the criteria area for the NAME field I put If Len([CUST]![NAME])>=30 It says the expression contains invalid syntax? I figured that the "If" is not needed so I tried Len([CUST]![NAME])>=30 too but it put quotes around the 30, and then it gave me a ton of names that were signaficantly less than 30 chars long. HELP! THANKS!

 

[KenHigg]

Do a new col in your query and put fldLen: Len([NAME])

Then in the criteria put >=30

???
kh

 

[Dano]

Ah HA!

Awesome! Thanks you so much! You are a Gentleman and a Scholar!

 

[KenHigg]

Cool -


.