Counting characters (1 Viewer)

[anthonyphillips]

Hi All

I need to create a qry that counts the chars in memo fields as if below 255 i can change it to a text field.

Thanks

Ant

 

[jdraw]

Hi All

I need to create a qry that counts the chars in memo fields as if below 255 i can change it to a text field.

Thanks

Ant

Try Len(memofield)

 

[anthonyphillips]

Try Len(memofield)

Yeah i read that, but where do i put it within the qry window, or do i have to code??

Sorry i'm not very good with access.

Ant

 

[boblarson]

You will need to find the longest string in ALL of your records, in the field, so this should do it (replace the table and field names with your own):

SELECT Max(Len([FieldNameHere])) AS FieldLength
FROM TableNameHere;