Len ?

  • Thread starter Thread starter Michael Peer
  • Start date Start date
M

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
 
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.
 
-----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)



Michael Peer said:
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
Click to expand...
Click to expand...


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.
 
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?

Michael said:
-----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)



Michael Peer said:
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
Click to expand...
Click to expand...

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.
Click to expand...
 
Back
Top