How to determine maximum size of field contents

P

Pat

How do I query the maximum size of the contents of a given text field? Also,
any suggestions on how to write a query to return the maximum size of the
contents of each text field in my database?

I'm using Access 2003.

Thanks,
Pat
 
J

John Spencer

Len(fieldName) will give you the size of the contents of the field.

For any one table you can do the following query.
SELECT Max(Len(FieldA)) as ASize
, Max(Len(FieldB)) as BSize
, Max(Len(FieldC)) as CSize
, Max(Len(FieldD)) as DSize
FROM YourTable

If you want to get the max len of each field of each table, then I would
write a VBA procedure to step through every table and every field and store
the results in a table for reporting/analysis.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
P

Pat

Thanks John, that's what I needed to know!

Pat

John Spencer said:
Len(fieldName) will give you the size of the contents of the field.

For any one table you can do the following query.
SELECT Max(Len(FieldA)) as ASize
, Max(Len(FieldB)) as BSize
, Max(Len(FieldC)) as CSize
, Max(Len(FieldD)) as DSize
FROM YourTable

If you want to get the max len of each field of each table, then I would
write a VBA procedure to step through every table and every field and store
the results in a table for reporting/analysis.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
Click to expand...
 
Top