count number of characters in acess memo field

  • Thread starter Thread starter MJ
  • Start date Start date
M

MJ

Hi,

I have an access table with 1 column (memo).

I need to count the number of characters for each record
(about 20,000) and then I need to count how many records
are over a certain size. How would I do that ? Thanks
 
Create a query into your table.

Type something like this into the Field row of your query:
Len([MyField])
where "MyField" represents the name of your memo.

You can add criteria to limit the query to only records where the length is
above a certain size.
 
MJ said:
Hi,

I have an access table with 1 column (memo).

I need to count the number of characters for each record
(about 20,000) and then I need to count how many records
are over a certain size. How would I do that ? Thanks
Click to expand...

Here are various queries to do some of the things you ask:

Return number of characters for each record:

SELECT
tblMemo.MemoField,
Len([MemoField]) AS MemoLength
FROM tblMemo;

Return only records with records over a parameter-specifed size:

SELECT
tblMemo.MemoField,
Len([MemoField]) AS MemoLength
FROM tblMemo
WHERE
Len([MemoField])>[Records over how many characters?];

Return total number of characters in all records:

SELECT
Sum(Len([MemoField])) AS TotalLength
FROM tblMemo;
 
Back
Top