find records from number of charachters in a field

noccy

Registered User.
Local time
Today, 12:00
Joined
Aug 19, 2003
Messages
67
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 =(
 
Just build an UPDATE query. Why make it so complicated?
 
yeah, i thought of that, but i dont know how to ask for a certain number of charachters........


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


tnx m8 =)
 

Users who are viewing this thread

Back
Top Bottom