I can not sort hyperlink field in the query

[Masoud]

Hello
My query is like below, hyperlink field will not be sort in data sheet
view.out put data is like below:
Please help.

thanks in advanced.

Unit No Line Size Fluid Code Unit No Iso Pipe Sequence No Piping
Class Insulation Code hyper
100 10 G 100 20014 G03P2 N 10-G10020014-G03P2-N_Sht_3.pdf

100 10 G 100 20014 G03P2 N 10-G10020014-G03P2-N_Sht_4.pdf

100 10 G 100 20014 G03P2 N 10-G10020014-G03P2-N_Sht_1.pdf

100 10 G 100 20014 G03P2 N 10-G10020014-G03P2-N_Sht_2.pdf




my query:

SELECT DISTINCTROW qryiso.[Unit No], qryiso.[Line Size], qryiso.[Fluid
Code], qryiso.[Unit No Iso], qryiso.[Pipe Sequence No], qryiso.[Piping
Class], qryiso.[Insulation Code], tblfilename.hyper, qryiso.[Total Sheet No],
qryiso.[Issue Date], qryiso.[MaxOfIsometric Drawing Rev],
qryiso.[MaxOfIsometric Drawing List Rev], qryiso.[Issued For], qryiso.Remark,
qryiso.[DOC No], qryiso![Line Size] & "-" & qryiso![Fluid Code] & "-" &
qryiso![Unit No Iso] & "-" & qryiso![Pipe Sequence No] & "-" & qryiso![Piping
Class] & "-" & qryiso![Insulation Code] AS [line No]
FROM qryiso LEFT JOIN tblfilename ON (qryiso.[Line Size]=tblfilename.[Line
Size]) AND (qryiso.[Fluid Code]=tblfilename.[Fluid Code]) AND (qryiso.[Unit
No Iso]=tblfilename.[Unit No Iso]) AND (qryiso.[Pipe Sequence
No]=tblfilename.[Pipe Sequence No]) AND (qryiso.[Piping
Class]=tblfilename.[Piping Class]) AND (qryiso.[Insulation
Code]=tblfilename.[Insulation Code])
WHERE (((qryiso.[DOC No]) Like "*001" Or (qryiso.[DOC No]) Like "*003"))
ORDER BY qryiso.[Unit No], qryiso.[Line Size], qryiso.[Fluid Code],
qryiso.[Unit No Iso], qryiso.[Pipe Sequence No], qryiso.[Piping Class],
qryiso.[Insulation Code], tblfilename.hyper;

 

[Alex Dybenko]

Hi,
you can create new calculated field in your query like
Left([Hyperlinkfield], 255) and sort by it

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com