Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

order by not working

Status
Not open for further replies.
rry2k

rry2k

Programmer
Jun 28, 2001
678
US
I have a subform that I would like to show records based on date ascending. I put in the datefield in the order by clause but it didn't change. Any ideas would be greatly appreciated.

Thanks..Russ
 
Sort by date Sort by votes
Post the entire SQL here so we might have a look and formulate some ideas. Thanks
 
Upvote 0 Downvote
I got it resolved. I needed to set orderby to true in code and then it worked.

Thanks..Russ
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Solved
Split Function not working
Replies
3
Views
184
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question
Code not working 1
Replies
5
Views
236
Darrylles
Darrylles
Moss100
  • Locked
  • Question
Vba filter not working 3
Replies
7
Views
323
Cole Mendoza
Cole Mendoza
theConjurian
  • Locked
  • Question
DoCmd.Close not working
Replies
1
Views
178
kjv1611
kjv1611
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
516
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top