Thread: Listing Category then Items
View Single Post
  #3 (permalink)  
Old December 12th, 2003, 06:43 AM
pgtips pgtips is offline
Friend of Wrox
  
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default
Just noticed that you need an ORDER BY clause in your SQL to ensure that the Categories are sorted in your recordset
Code:
"SELECT Category, Item FROM Table1 WHERE Start_Date <= '" & Date & "' ORDER BY Category, Item";
Reply With Quote