Len ?

[Michael Peer]

I have a simple (or it seems it should be) problem. I have
a table named "Input_data" with a field named "Profiles_1".
I need to know the length of the data in this field for
each record in the table. How can I do this???
Thanks

 

[Van T. Dinh]

A Query with the SQL String:

SELECT [Profiles_1], Len([Profiles_1])
FROM [Input_Data]

will give the value of [Profiles_1] and its length for each Record in your
Table.

 

[Michael Peer]

-----Original Message-----
A Query with the SQL String:

SELECT [Profiles_1], Len([Profiles_1])
FROM [Input_Data]

will give the value of [Profiles_1] and its length for each Record in your
Table.

--
HTH
Van T. Dinh
MVP (Access)

I have a simple (or it seems it should be) problem. I have
a table named "Input_data" with a field named "Profiles_1".
I need to know the length of the data in this field for
each record in the table. How can I do this???
Thanks

OK, I see how that would work. But let me change the
scenerio a bit. Let's say that I need to find the length
of the data in "Profiles_1" and if it is greater than X
then do this, otherwise do this. Then go to the next
record and do the same until the end of the records. How
would I do that?
Thanks for your help.

 

[John Spencer (MVP)]

It kind of depends on what Do this and Do That are and how complex these actions are.

For instance, do you want to perform a calculation and show a result? Do you
want to update different fields? Do you want to append records in one case and
delete records in the other?

-----Original Message-----
A Query with the SQL String:

SELECT [Profiles_1], Len([Profiles_1])
FROM [Input_Data]

will give the value of [Profiles_1] and its length for each Record in your
Table.

--
HTH
Van T. Dinh
MVP (Access)

I have a simple (or it seems it should be) problem. I have
a table named "Input_data" with a field named "Profiles_1".
I need to know the length of the data in this field for
each record in the table. How can I do this???
Thanks

OK, I see how that would work. But let me change the
scenerio a bit. Let's say that I need to find the length
of the data in "Profiles_1" and if it is greater than X
then do this, otherwise do this. Then go to the next
record and do the same until the end of the records. How
would I do that?
Thanks for your help.