Field Length

  • Thread starter Thread starter mw
  • Start date Start date
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
 
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.
 
Back
Top