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

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)

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

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;