Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms Coding > More Sorting "c...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 41508 of 43412
Post > Topic >>

More Sorting "coding" help needed

by "Dave" <dave@[EMAIL PROTECTED] > Aug 5, 2008 at 04:32 PM

Access 2007

Based upon 3 fields. Caller (text field), Status (Combo), Inactive (Y/N)

I want to first sort alphabetically by caller
Then
Status = Ineligible
Then
 Inactive 


This is the attempt I made - which did not work.

[code]

Private Sub cmdSortCaller_Click()
    Me.OrderBy = "Caller"
    Me.OrderBy = "Status = Ineligible" & " Desc"
    Me.OrderBy = "Inactive" & " Desc"
    Me.OrderByOn = True
End Sub

[/code]

Any help will be appreciated

Dave
 




 4 Posts in Topic:
More Sorting "coding" help needed
"Dave" <dave  2008-08-05 16:32:07 
Re: More Sorting "coding" help needed
"Allen Browne"   2008-08-06 09:53:52 
Re: More Sorting "coding" help needed
"Dave" <dave  2008-08-06 12:17:48 
Re: More Sorting "coding" help needed
"Douglas J. Steele&q  2008-08-06 15:30:30 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:46:56 CST 2008.