Order a text fileld

[Anonymous]

Hi everyone!

My problem is that i'm unable to order a text string fill with number...

I have use this function:

Select * From Bloc Where NoCarriere=" & Me.NoCarriere & " ORDER BY ([NoBloc]
Like '*[az]*'), Val([NoBloc]), Bloc.NoBloc"

The result:

111404
111568
1121027
1121055
1121058
112418
112482

The result I would like is:

111404
111568
112418
112482
1121027
1121055
1121058


Thanks in advance for your responses!!!!

JS

 

[Marshall Barton]

My problem is that i'm unable to order a text string fill with number...

I have use this function:

Select * From Bloc Where NoCarriere=" & Me.NoCarriere & " ORDER BY ([NoBloc]
Like '*[az]*'), Val([NoBloc]), Bloc.NoBloc"

The result:

111404
111568
1121027
1121055
1121058
112418
112482

The result I would like is:

111404
111568
112418
112482
1121027
1121055
1121058

The result you're seeing is because Val could not convert
the field values to numbers. I think we will need to see
the original field values, maybe they have a leading space
or some other nonnumeric character. I would at least like
to see where/how the a or z fits into the problem.