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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting Long String Field from SQL Server into Access Query/Rep 1
Deleting Duplicate Records in a Query 5
ALTER TABLE query - "Allow zero length" 2
Max SQL length for Passthrough Query 2
Query. How to add this calculated field? 2
Query / Count Length Of Field 3
adding additional criteria to MIN( sub query 2
Convert to text 13

Back
Top