Length of answer

[AccessSHELL]

I have a table with 2 fields. We can call them Field1 and Field2

I need to sort the table ascending by the length of Field2. I am having some trouble.

Please help.



Thanks

[AccessSHELL]

I got it. Thanks

[Welshgasman]

So please post your solution, as it might help others.
After all, that is what these forums are about?

[AccessSHELL]

SELECT tblQA.Field1, tblQA.Field2, Len(([Field1])) AS Length FROM tblQAORDER BY Len(([Field1]));

[Welshgasman]

SELECT tblQA.Field1, tblQA.Field2, Len(([Field1])) AS Length FROM tblQAORDER BY Len(([Field1]));

Thanks for the solution.