Senin, 11 April 2016

Re:[MS_AccessPros] Re: Order question in query.

 

Bill-
This is the result I want:
===tblGroupBooking====
Checkin        GroupCode
2016-May-01    abc001-A
2016-May-05    abc001-B
2016-May-08    abc001-C
2016-May-02    def002
2016-May-03    def003
                       
Best Regrds,
Kevin


Life has an uncanny way of responding to your need.
在 "wrmosca@comcast.net [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>,2016年4月12日 上午5:26写道:

 

Kevin


I'm not understanding what you mean by "they should stick together". The sort order should still work even though the group code is a little longer. 

What results are you getting now and what is your query?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <zhaoliqingoffice@163.com> wrote :


Dear All,

Is the possible to get this done by query?

===tblGroupBooking====
Checkin        GroupCode
2016-May-01    abc001-A
2016-May-05    abc001-B
2016-May-08    abc001-C
2016-May-02    def002
2016-May-03    def003
                       

I want the check in to be the first order, and BroupCode the second order. But If the group code has the same prefix (e.g. abc001), then they should stick to one another. Is that possible? Or is there's any other way to make the outcome look like this? Thanks in advance.

Best Regards,
Kevin

 

__._,_.___

Posted by: zhaoliqingoffice <zhaoliqingoffice@163.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar