Order a text fileld

  • Thread starter Thread starter Anonymous
  • Start date Start date
A

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
 
Anonymous said:
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
Click to expand...


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.
 
Back
Top