By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,469 Members | 2,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,469 IT Pros & Developers. It's quick & easy.

Maximum *width* of data in a table (Access 2003)

P: n/a
Greetings:

Is there any way to determine the maximum width of all data elements
in a particular column in a table? Sorting a column won't do it, of
course, since it will use a collating sequence based on the content of
the data. I want to know, for example, that the maximum width of a
(non-blank) populated field in a table is, say, 10 (even though the
field itself may be defined as width-255).

Many thanks.

Jun 2 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sat, 02 Jun 2007 21:36:53 -0000, RK********@gmail.com wrote:
>Greetings:

Is there any way to determine the maximum width of all data elements
in a particular column in a table? Sorting a column won't do it, of
course, since it will use a collating sequence based on the content of
the data. I want to know, for example, that the maximum width of a
(non-blank) populated field in a table is, say, 10 (even though the
field itself may be defined as width-255).

Many thanks.

Make a query of the table showing only the one column in question.
Add a calculated column, say for the length of a persons last name,
lgthLastName:([LastName])
set sort order to Descending

Just a wizard prodder
Chuck
--
Jun 2 '07 #2

P: n/a
On Sat, 02 Jun 2007 21:36:53 -0000, RK********@gmail.com wrote:
Greetings:

Is there any way to determine the maximum width of all data elements
in a particular column in a table? Sorting a column won't do it, of
course, since it will use a collating sequence based on the content of
the data. I want to know, for example, that the maximum width of a
(non-blank) populated field in a table is, say, 10 (even though the
field itself may be defined as width-255).

Many thanks.
What do you mean by "maximum width"?
The number of characters in the field?
In a query?
Add a new column:
MostChars:Len([FieldName])

Set this column to sort Descending
The record with the most characters will be first.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Jun 3 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.