find records from number of charachters in a field

[noccy]

Hello!

In a table I want to find all the records where a certain field contains exactly 255 charachters.

The results I want to put into a new table

Any suggestions?

I was thinking something like a DAO connection with an sql string to find the records, and then a With.rst........ to create a new table.


Can't seem to get it right tho =(

 

[Mile-O]

Just build an UPDATE query. Why make it so complicated?

 

[noccy]

yeah, i thought of that, but i dont know how to ask for a certain number of charachters........


noccy

 

[Mile-O]

Look at your post in the queries section then.


i.e. this one

 

[noccy]

hehe as I said i had thougt of both methods, and asked about both as well


tnx m8 =)