D
deanboy
LarryH said:
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
LarryH
I need to be able to find the longest record in each field, and its length
and produce a report with the information.
and produce a report with the information.
K
KARL DEWEY
You are using the terms 'record' and 'field' backwards.
A record has fields, therefore you would have 'longest field in a record.
If you table had the following fields - Name, Type, and Agerotia you would
use a union query like this first --
SELECT "Name" AS [Field], Len([Name]) AS [Size]
FROM YourTable
UNION ALL SELECT "Type" AS [Field], Len([Type]) AS [Size]
FROM YourTable
UNION ALL SELECT "Agerotia" AS [Field], Len([Agerotia]) AS [Size]
FROM YourTable;
Run it and then click on the Z-A sort.
A record has fields, therefore you would have 'longest field in a record.
If you table had the following fields - Name, Type, and Agerotia you would
use a union query like this first --
SELECT "Name" AS [Field], Len([Name]) AS [Size]
FROM YourTable
UNION ALL SELECT "Type" AS [Field], Len([Type]) AS [Size]
FROM YourTable
UNION ALL SELECT "Agerotia" AS [Field], Len([Agerotia]) AS [Size]
FROM YourTable;
Run it and then click on the Z-A sort.
J
James A. Fortune
LarryH said:I need to be able to find the longest record in each field, and its length
and produce a report with the information.
I did an operation like that in:
http://groups.google.com/group/comp.databases.ms-access/msg/537cd6d52ff30ac2
I think today I might create such a flexible report differently than I
did back then. Still, the way it worked is interesting.
James A. Fortune
[email protected]
O
Otoniel Castillo Norales
LarryH said:I need to be able to find the longest record in each field, and its length
and produce a report with the information.
A
aaron.kempf
select sc.name, object_name(sc.id) as tblName, sc.length, sc.type
from syscolumns sc
where id in (select id from sysobjects where xtype = 'u')
from syscolumns sc
where id in (select id from sysobjects where xtype = 'u')
A
aaron.kempf
select 'select ' + char(39) + sc.name + char(39) + ' as ColName, max
(Len(' + sc.name + ')) from tbl'
from syscolumns
where id = object_id('tbl')
(Len(' + sc.name + ')) from tbl'
from syscolumns
where id = object_id('tbl')