thank you Mr.Tumblu
i didn't undestand your reply can you please explain some what easy way
because i am not an advance user in access iam just begining stage
faisal
riyadh
L Tumbulu <[EMAIL PROTECTED]> wrote:
Hi Muhamed
Assuming that in all the field records the numbers come after a colon (:) then
you can enter the following expression in a query field and then sort the
records according to this field.
Val(Mid([Session],InStr([Session],":")+1,4))
I've used 4 assuming that the there can be up to 4 digits after the collon.
Session is a field name (use your field name).
Hope this helps
Liveson
----- Original Message -----
From: Muhamed Faisal
To: [email protected]
Sent: Wednesday, 31 October, 2007 07:24
Subject: Re: [ms_access] sorting order
dear tumbulu ,
in my query i have text string line no (for eg line no:1,line no:2,....line
no:10) and carsponding data like qty produced and damaged etc.
and if i sort the result in ascending or descendig order in line no the result
is that line no:10 is near to line no:1 this is my problem,
i want to display line no:10 after line no:9
any tips pls
faisal
riyadh
L Tumbulu <[EMAIL PROTECTED]> wrote:
Muhamed
You need to explain how your data is arranged and how you want it to be sorted
and we may be able to help you achieve that if it is possible.
Regards
Liveson
----- Original Message -----
From: Muhamed Faisal
To: [email protected]
Sent: Tuesday, 30 October, 2007 07:21
Subject: Re: [ms_access] sorting order
thank you for yor reply,
i want to sort in a complex way other than the ascending or descending availble
in designing view
pls help me to solve this matter.
thanks & regards
faisal
riyadh
----- Original Message ----
From: Lonnie Johnson <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, October 30, 2007 5:57:00 AM
Subject: Re: [ms_access] sorting order
In the query grid (design view) there is a line for sorting. Here you choose
ascending or descending for the fields you want to sort on.
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev. us
----- Original Message ----
From: Muhamed Faisal <muhamed_faisal2000@ yahoo.com>
To: [EMAIL PROTECTED] ps.com
Sent: Monday, October 29, 2007 7:29:53 AM
Subject: [ms_access] sorting order
dears,
can you any body help me to make a query from one table and in this query i
want to disply the datas in an special sorting order.
thanks and regards
Faisal
Riyadh
____________ _________ _________ _________ _________ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. yahoo.com
[Non-text portions of this message have been removed]
____________ _________ _________ _________ _________ __
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail. yahoo.com
[Non-text portions of this message have been removed]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
