OK here is the setup of my database

Table #1 Name = Lists

Fields:

ListName
ItemName
AmtNum
AmtType

Table #2 Name = Items

Fields:

ItemName
Category

Now what I want to do is Open a recordset with an SQL statement similar to this and have it sorted by Category

sSQL = "SELECT * FROM Lists WHERE ListName = '" & pListName & "' ORDER BY Items.Category ASC;"

However (obviously) this doesn't work, how can I get this recordset sorted by category using an SQL statement, any ideas?