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;

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


"Masoud" <(E-Mail Removed)> wrote in message
news:F02B1A7A-7B69-4C91-86CA-(E-Mail Removed)...
> 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;