Field Length

M

mw

I'm trying to query field length of a text field through SQL. Anyone got
any ideas how to write that? I think I could do it with SQL Server, but not
sure how to with Access.

Thanks.

m
 
J

John Vinson

I'm trying to query field length of a text field through SQL. Anyone got
any ideas how to write that? I think I could do it with SQL Server, but not
sure how to with Access.
Click to expand...

Use

FieldLength: Len([fieldname])

as a calculated field in the Query.
 
Top